question

MarianCretu asked Jun 27, '19 Joseph Gillespie edited Jun 27, '19

Trouble with random pull

Hello all,

Please help with this matter.

I have 4 queues in a Fixed Resource list.

I want to pull a random queue with queue size < 2 by using this query "WHERE queueSize < 1 ORDER BY Random ASC".

The problem is that it always pulls the first queue.

Software Version:

FlexSim 19.1.1

Joseph Gillespie answered Jun 27, '19

Your problem was with "Random ASC". This code should do the trick:

WHERE queueSize < 1 ORDER BY RAND()

Let us know if you have any more questions!