topic Re: Lists Query using Puller.[label] vs token.[label] in FlexSim Forum

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

zbarachki — Mon, 16 Jan 2023 19:59:52 GMT

[ FlexSim 22.2.2 ]

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.

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

JordanLJohnson — Mon, 16 Jan 2023 20:36:12 GMT

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.

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

zbarachki — Mon, 16 Jan 2023 20:45:38 GMT

@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?

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

JordanLJohnson — Mon, 16 Jan 2023 20:48:43 GMT

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

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

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

zbarachki — Mon, 16 Jan 2023 20:50:08 GMT

Thank you for quick responses!

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

jason_lightfoot_adsk — Mon, 16 Jan 2023 22:38:06 GMT

You can refer to the object to pull as token.labelname directly when it's not part of a query and when token.labelname points to the object to pull or contains an array of objects to pull. This corresponds to the three qualifier types shown two fields above the Puller field in Jordan's image which is marked as "Query / Object / Array".