Lists and resources seem to have a problem when the pull or acquire query access a label on a label using dot syntax. In the attached model I am creating items in a queue and in the pull action on the top I am trying to find a token for which the token's item has a Product with a particular value. The pull throws an "Invalid SQL Query" error and breaks.
The second option, using the old-fashioned getlabel syntax, does work.
Is this supposed to happen?
Unfortunately queries are parsed using our SQL parser which is a completely different parser than the compiler uses for FlexScript. We made the SQL parser work with a single label accessor, but adding functionality for multiple label accessors is not trivial. At some point we would like to add this in. We'll add this to the dev list.
Maybe you should use unique names for your labels. If you do so, then the condition
puller.Product = value.Producte
seems to work.
I added to the label name "Product" simply the letter "e".
6 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.
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.
