question

chukiat avatar image
0 Likes"
chukiat asked chukiat commented

Query command in Pull from List

Hello, I just start to learn Flexsim

My problem that I try to pull by refer order by label.name with pull q'ty = 5 and each pull time must pull only 1 label.name.

But I can't find the command that get result as my expect

I send picture for more clearly what I expect

Can anyone help for this issuedscreenshot-2023-07-13-164049.jpg

FlexSim 23.1.1
pull from list
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Natalie White avatar image Natalie White commented ·

Hi @chukiat, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of the answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept the answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered chukiat commented

To filter the list by certain conditions use the WHERE clause.

WHERE Model == puller.Model

See the documentation for more information

SQL with lists

SQL in general

· 6
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

chukiat avatar image chukiat commented ·

Hi Felix

Thank you for your answer

I put WHERE Model == puller.Model in Query command but nothing happen (not pull anything)

Do you have some sample for this command that I can refer

0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann chukiat commented ·
Is the "Model" label present on both the pulling token and the values on the list?

If you don't know what a token should pull beforehand, you can have it pull the first available value first (no query) and then pull additional values with the same label.

0 Likes 0 ·
chukiat avatar image chukiat Felix Möhlmann commented ·
Hi Felix

Thank you very much

Now, I can do by refer label name from value of first pulled item

0 Likes 0 ·
Show more comments