I am not having any success getting the query() command to work in process flow. Can someone tell me if I am doing something wrong in the attached model?
The reason I want to use query() vs just having a Pull From List activity pulling 0 tokens is that what I really need is a query with a join, which IIUC I can't do on a Pull From List (since the "FROM " is implied).querying-a-list.fsm
Thanks, Craig
Thanks for sending in your model. This model shows a bug in the query command. As far as I can tell, the bug means that you can't currently use the $ syntax if you are querying a list. That bug is going on the dev list right away.
The query command does work, however, if you make a query that has the right values, rather than using the $ syntax. You can make the query itself a variable. In the attached model (which is a modified version of the one you sent), I used a decide to set a query label on the token. Then I use that label value at the query for the query command. You could also construct the query you need (using the concat() and numtostring() commands).
@jordan.johnson (off topic) could you perhaps discuss at Flexsim to add a topic named " known bug" to identify bugs discovered in answerhub forum to find them easier, if someone find a similar behaviour again? As I suggested here.
@jordan.johnson I was able to get your small model to run, no problem. But I still get an error when I apply the same in my much larger model. I'll send you the whole model in a private question to see if you can help me figure out what I am doing differently.
5 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
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.
