product_query.fsmI am trying to read specific values from a table using Table.query().
More specifically, in my attached flexsim model I am trying to read rack_idx column value of a specific product_variant_id from global table planogram.
But, the model shows an error that the query sentence could not be parsed.
Please help me in finding the issue in my model/code.
Thanks!
Table Temp = Table.query("SELECT * FROM planogram WHERE product_variant_id = $1" ,token.product_variant_id);
SQL query syntax is incorrect in your model. The label value on the token needs to be added as a parameter in the query. You need to update as mentioned above in the code.
The problem is that the field is a string so you need to either put the value in apostrophes to make it compare the actual value rather than look for a column with that name, or pass it in as a parameter as @Arun Kr mentions (this second option has been known to not work in some queries in some versions - so apostrophe wrapping may be the technique most certain to work in all versions).
Table Temp = Table.query("SELECT * FROM planogram WHERE product_variant_id = '"+ token.product_variant_id+"'");
13 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.
