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.
@Matt Long What happens then in the statement I posted? puller.Product = value.Producte
That works just fine because you're using a single label accessor on puller and value. Where you would run into issues was if you said puller.Product.serial = value.Producte.serial
Thanks for both the reply, and considering this for a future release. One of the reasons I love the dot notation is because I got a bit tired (and confused) with writing getlabel(getlabel(...)) :-)
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.
