topic Re: Pull all items from list that satisfy sql query in FlexSim Forum

Pull all items from list that satisfy sql query

JayTea00 — Tue, 07 Nov 2023 11:44:21 GMT

[ FlexSim 23.2.2 ]

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

Re: Pull all items from list that satisfy sql query

moehlmann_fe — Tue, 07 Nov 2023 11:55:57 GMT

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.

Re: Pull all items from list that satisfy sql query

JayTea00 — Tue, 07 Nov 2023 14:21:39 GMT

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