My model has a pull from list item which references a global table to run a subtask if the tokens pushed in satisfy the type and quantity on the global table for the current day. Once the tokens enter the IQWaferInspection subtask, they have a NULL label which is my pull from list selection criteria ((P+).WaferArrivalQty >= .DemandQty). The task error shown below appears at midnight on 1/3/2024 when the first token reaches the load task of the IQWaferInspection subtask.
I believe you want to use WHERE rather than SELECT to filter for items with a large enough 'WaferArrivalQuantity' (SELECT writes the value to a label). And the 'DemandQty' label is present on the puller, so it should be "WHERE WaferArrivalQuantity >= puller.DemandQty".
The 'involved1' value (item to load) shows as blank because you are pulling tokens from the list. Tokens can't be loaded. You need to copy the 'item' label from the pulled token to the puller.
The same is true for the other Pull from List as well.
Hi Felix, thank you for your answer. That did resolve my problem and the model runs, however, now I get a message in the compiler console that says "syntax error, unexpected where, expecting end of code". What is the proper syntax to use?
My current query is WHERE WaferArrivalQty >= Puller.DemandQty WHERE WaferArrivalType = Puller.DemandType
WHERE condition1 AND condition2
See also https://docs.flexsim.com/en/25.0/Reference/DeveloperAdvancedUser/SQLQueries/SQLQueries.html
11 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.
