question

Bing L avatar image
0 Likes"
Bing L Suspended asked Ryan Clark commented

order by query

In pull from list activity,I want the query condition is ORDER BY RAND() and ORDER BY num ASC,but,It did not work as pic settings,how could I achieve it? thanks1647796330(1).jpg

FlexSim 22.0.1
pull from list
16477963301.jpg (20.9 KiB)
· 1
5 |100000

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 Felix Möhlmann edited

That query seems to work fine for me. The tokens are created with labels in the order of GlobalTable1 (Col 1 => num). GlobalTable2 shows the order in which they were pulled.

1647798661918.png

Could you provide some more detail in what way the query doesn't work in your model?


1647798661918.png (93.7 KiB)
· 2
5 |100000

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