How to randomise the order of a recordlist?

How to randomise the order of a recordlist?


Hi all,

I would like to know how I could make the sorting of a recordlist random, so the order of all the records in the list will be sorted random each time the action is called.

Anyone knows a solution for this?



I would say that you can create a new column, add random numbers and than use ListSort in that column to sort "randomly".

Forge has some components that return random numbers and random number lists. Just search by Random.

Also, if you pretend to return the result from database already sorted randomly, probably this topic in Stack Overflow will be of use (but will require an Advanced Query, as I don't think it is possible to do this with an Aggregate).

Hope this helps...