How to query by text label

Question

question

Scott Ainsworth asked Oct 12 2018 at 3:58 PM Joerg Vogel commented Jul 21 2021 at 5:22 PM

How to query by text label

If I pull from a list and use a query like:

WHERE BatchVal = Puller.Batch

It works fine if the BatchVal label is a number and Puller.Batch is a number.

If I query:

WHERE BatchText = Puller.Batch

It does not work if BatchText and Puller.Batch are text labels.

However if I query

WHERE BatchText = "The text"

It does work. However, I'm stuck with static query that does not modify for the next incoming token.

I would like to query the batch with a text label so I can pull the tokens with matching text label.

Software Version:

FlexSim 18.2.2

pull from list queries no result

· 4

tannerp commented · Oct 12 2018 at 5:13 PM

Would you be able to upload your model or a small recreation of the problem? It would make it easier for us to recognize what needs to happen and provide a good solution.

1 ·

Jeff Nordgren commented · Oct 12 2018 at 5:21 PM

@Scott Ainsworth

Does (token.Puller.Batch) work?

0 ·

Scott Ainsworth Jeff Nordgren commented · Oct 16 2018 at 2:12 PM

No it does not work. I'll try to pull an example together. All the documentation on queries in the manual use numbers.

0 ·

tannerp Scott Ainsworth commented · Oct 17 2018 at 4:02 PM

Is your data type set as "string" and not "number"? An example of how to change/verify this is shown in this image:

-1 ·

string-label-data.png (38.1 KiB)

______

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 · 2018-10-16T23:15:54Z

Joerg Vogel answered Oct 16 2018 at 11:15 PM Joerg Vogel commented Jul 21 2021 at 5:22 PM

I haven't got any problems to pull by strings from a list. Please see attached model.

pull-by-string.fsm

WHERE Puller.batch = batchId

This works, where batchId is a list entry of string values, Puller is the token, batch is a label at the token containing a string.

The result contains a NULL if there is not a possible match.

pull-by-string.fsm (23.7 KiB)

· 2

question