Pull all items from list that satisfy sql query

Question

question

Peter asked Nov 7, '23 Peter commented Nov 7, '23

Pull all items from list that satisfy sql query

Hey,

Is there a way in the to use the 'pull from list' block in a way that it pulls all entries from the list that satisfy the sql pull-query?

So for instance: I have 10 items on the list with an age. Then I want all items that are older than 20 s (WHERE age >= 20) to be pulled when 1 token arrives. So, for instance the 6 of the 10 items that are older than 20 s will be pulled.

How is that done?

Thanks

Software Version:

FlexSim 23.2.2

list pull sql query pull item

5 |100000

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

Answer 1 · 2023-11-07T11:55:57Z

Felix Möhlmann answered Nov 7, '23 Peter commented Nov 7, '23

A token will pull at least as many entries as the Require number mandates, up to a maximum value which is represented by the Request number.

To potentially pull anywhere from 0 to all values on the list, set the request number to be very high (larger than the highest quantity of values you ever expect to be on the list at any time) and set the require number to 0.

· 1

5 |100000

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

Peter commented · Nov 07, 2023 at 02:21 PM

Thank you this is exactly what I needed, somehow I missed this fucntion

0 ·

question