I am trying to push an item to a list and later I am pulling the item with a WHERE clause? I make something totally wrong, because I can't get it working. It is just a small example. The item gets to the list in the onEntry trigger of the queue and is pulled in the onExit trigger of the processor.
WHERE id == tonum(item)
The id contains the same item converted to a number in the onEntry Trigger.
Is there an easier approach, because the reference is already on the list? It is the value column.
@Cameron Pluim is close: item does not exist within the scope at which the query is evaluated, but you are already passing it in as puller in the fourth argument to List.pull so no need to do string conversions.
Inside the query, you can access the item as puller and something like
WHERE id == tonum(puller)
should work (untested though).
The following code should work:
"WHERE id = " + numtostring(tonum(item))
I think the issue is that "item" is unknown within the scope of list.pull so you need to change it to a number before putting it in the string. But that is just my guess.
@Cameron Pluim. Thank you for your suggestion! Your approach works, too. The code must be inserted into the code editor, because in the template editor I can't end the quotation marks. The editor convert them to a character and not to a part of the code.
8 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
