question

Steven Chen avatar image
0 Likes"
Steven Chen asked tannerp commented

List Pull Dynamic Requirements

Hello,

I write a query like "WHERE Type IN (1,2,3)", that equal to "WHERE Type=1 OR Type=2 OR Type=3".

The requirements (1,2,3) is dynamic. I tried to use array label to store the type requirements and add to query with script.

Since 18.2 beta support writing script in query string, I imagine the query could be something like "WHERE Type IN ({token.reqTypes})" but it's wrong.

So is there other solution to construct dynamic query?

FlexSim 18.1.2
listquerypull
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Joshua S avatar image
0 Likes"
Joshua S answered

Here's a model to demonstrate what you want. In your query, you should use "Puller" rather than token.

query-example.fsm


query-example.fsm (27.9 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.