question

Peter avatar image
0 Likes"
Peter asked Peter commented

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

FlexSim 23.2.2
list pullsql querypull item
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

·
Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered Peter commented

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
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.

Peter avatar image Peter commented ·

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

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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