question

Pinakin K avatar image
0 Likes"
Pinakin K asked Pinakin K commented

Is there a way to select list based on available entrie?

I want to pull from the list which has entries available

FlexSim 20.2.3
flexsim 20.2.3lists
· 3
5 |100000

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

Joerg Vogel avatar image Joerg Vogel commented ·

If it is a global list, then you query this list as a table and use a SELECT clause. You parse the list name in the FROM clause.

1 Like 1 ·
Pinakin K avatar image Pinakin K Joerg Vogel commented ·

@Jörg Vogel Thanks, this can work.

0 Likes 0 ·
Parker S avatar image Parker S ♦ commented ·

Are you asking how to use the query function on a Pull from List activity? Or do you have multiple lists and you want to pull from one conditional that it has entries?

Please be more specific in your question.

0 Likes 0 ·

1 Answer

·
Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered

If you want to check, that a list has got entries then you have the property length to get this answer. This property returns the entries of a partitioned or none partitioned list as an integer value.

5 |100000

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

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.