List Pull Dynamic Requirements

Question

question

Steven Chen asked Jul 24, '18 tannerp commented Jul 27, '18

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?

Software Version:

FlexSim 18.1.2

list query pull

Answer 1 · 2018-07-24T14:32:15Z

Joshua S answered Jul 24, '18

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)

question