question

Karan avatar image
0 Likes"
Karan asked Jason Lightfoot edited

Lists Query using Puller.[label] vs token.[label]

Hi,

When pulling from a list, I have mostly been using WHERE ____ = token.[label]
However, I recently got a few errors and noticed that if I changed it to WHERE ___ = Puller.[label], then the query worked perfectly.

Why is it that the token reference worked in some cases? How can I find out what the difference might be between these lists? I would prefer the token reference to work because that is the default action when writing a query, not that typing Puller is any harder. Just curious.

FlexSim 22.2.2
querypull from list
5 |100000

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

1 Answer

·
Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Jason Lightfoot edited

It is always correct to use "WHERE val = Puller.LabelName", and I'm fairly confident that it is never correct to use "WHERE val = token.LabelName". In fact, I'm somewhat surprised that it works for you in certain cases. I recommend you always use Puller.

As for why you use "puller" and not "token" in a list query, the quick answer is that you can make any node the puller, including a token, a Queue, a TaskExecuter, etc. Since anything can be the puller, it doesn't make sense to assume that "token" is the puller.

· 4
5 |100000

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

Karan avatar image Karan commented ·
@Jordan Johnson

Thank you for the explanation. I will begin using Puller from now on, however is the puller defined somewhere in the list settings or activities since you said any node could be a puller?

0 Likes 0 ·
Jordan Johnson avatar image Jordan Johnson ♦♦ Karan commented ·

If you are in Process Flow, the Pull From List activity lets you specify the puller:

1673902118833.png

https://docs.flexsim.com/en/22.2/Reference/ProcessFlowObjects/SharedAssets/PullFromList/PullFromList.html

1 Like 1 ·
1673902118833.png (21.3 KiB)
Karan avatar image Karan Jordan Johnson ♦♦ commented ·
Thank you for quick responses!
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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