How to query by text label

Question

question

Scott Ainsworth asked Oct 12, '18 Joerg Vogel commented Jul 21, '21

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 05: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 05:21 PM

@Scott Ainsworth

Does (token.Puller.Batch) work?

0 ·

Scott Ainsworth Jeff Nordgren commented · Oct 16, 2018 at 02: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 04: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)

Answer 1 · 2018-10-16T23:15:54Z

Joerg Vogel answered Oct 16, '18 Joerg Vogel commented Jul 21, '21

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

Guillaume V commented · Jul 21, 2021 at 03:42 PM

@Joerg Vogel
In your Query:

WHERE Puller.batch = batchId

You call the list by its name "batchId". What if "batchId" is kept inside of a label known by the puller inside "ListName".
I tried writing:

WHERE Puller.batch = Puller.ListName

Where Puller.ListName = "batchId" but it doesn't work :(

0 ·

Joerg Vogel Guillaume V commented · Jul 21, 2021 at 05:22 PM

Please ask a new Question. Your request hasn't got any relevance to the original question.

0 ·

question