Doubt with Pull from List

Question

question

Ruben M4 asked Jul 08 2021 at 9:50 AM Joerg Vogel commented Jul 08 2021 at 11:15 AM

Doubt with Pull from List

Good morning everybody!

I would like to make a list request based on a token tag that is going through the "Pull from list" operation. In this case in the FlexSim User Manual I see references to the WHERE command used with numbers, for example:
WHERE WHERE ID = 2, WHERE ID > 1 or WHERE Name = 'Operator2'

But I don't see any reference where you can access to the the label value of a token. I imagine it will be something like that:

WHERE ID = puller.ID or WHERE ID = token.ID

But I can't get the request right.

Software Version:

FlexSim 19.2.4

list pull from list pull query

· 1

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2021-07-08T10:40:25Z

Joerg Vogel answered Jul 08 2021 at 10:40 AM Joerg Vogel commented Jul 08 2021 at 11:15 AM

WHERE ID = puller.ID

would be correct. You need to address the Puller in your Picklist property or Process Flow activity.

List_Puller_PF.fsm

list-puller-pf.fsm (33.5 KiB)

· 3

Joerg Vogel commented · Jul 08 2021 at 11:12 AM

Naturally you must set the label under List "Advanced" properties to be present in your List.

As I did that, there was still the same behavior. As I converted the label and list entry field to be numbers the query worked.

proposal2-10_JV.fsm

1 ·

local-list-properties.png (14.0 KiB)

proposal2-10-jv.fsm (43.3 KiB)

Ruben M4 commented · Jul 08 2021 at 10:31 AM

proposal2_10.fsm

it doesn't work neither

0 ·

proposal2-10.fsm (45.2 KiB)

Joerg Vogel Ruben M4 commented · Jul 08 2021 at 11:15 AM

@Ruben M4 , Please see my latest comment under my answer! Thanks!

0 ·

Answer 2 · 2021-07-08T10:14:46Z

José Antonio MD answered Jul 08 2021 at 10:14 AM Ruben M4 commented Jul 08 2021 at 10:54 AM

Hello.

See "Puller" in Pull activity options, you will see by default its reference is "token". If you use "puller" insted of "token", you can filter using this information.

I hope I have been helpful.

19.1. Ejemplo Pull filter.fsm

191-ejemplo-pull-filter.fsm (22.9 KiB)

· 5

Ruben M4 commented · Jul 08 2021 at 10:23 AM

Hi and thanks for your answer.

I did what you said, but I continue having prblems with the SqlQuery

0 ·

screenshot-1.png (196.9 KiB)

José Antonio MD Ruben M4 commented · Jul 08 2021 at 10:26 AM

Hello,

If you see my example, I use "puller" in Query no "token".

In your example you should use something like this:

0 ·

1625739952858.png (49.1 KiB)

Ruben M4 commented · Jul 08 2021 at 10:32 AM

proposal2_10.fsm

it doesn't work either

0 ·

proposal2-10.fsm (45.2 KiB)

José Antonio MD Ruben M4 commented · Jul 08 2021 at 10:45 AM

If you filter information in the list, you need this information in the list. Please create Field in the list advance options (see user manual:https://docs.flexsim.com/en/19.2/Reference/ProcessFlowObjects/SharedAssets/List/).

If I check your logic, you have another problem, in the Push Activity your label is a number and a string in the Pull Activity, both have to be the same info type (update TipoCable to number info: right click and "Assign Number Data").

1 ·

1625740899092.png (100.2 KiB)

1625740940909.png (38.8 KiB)

Ruben M4 José Antonio MD commented · Jul 08 2021 at 10:54 AM

@José Antonio MD it is working. Thank you so much.

It was the info type for TipoCable.

0 ·

question