Sort elements in random order

Robert_LoopLabs

Hey everyone, is there a way in xano to sort elements in a random order, but to make that order consistent with pagination? Something like using a ORDER BY RAND(SEED) in sql. Similar to this stackoverflow quesiton: https://stackoverflow.com/questions/10729633/php-mysql-pagination-with-random-ordering

Thanks a lot!!

Chris Coleman

Hi @Robert_LoopLabs — not currently with a Query All Records. However, this may be possible using an SQL statement with our Direct Database Query function!

Jswan

Hey @Robert_LoopLabs & anyone else looking on! Got this working with @Chris Coleman's Direct Database Query suggestion.

You need two statements:

1. SELECT setseed(0.351);
2. SELECT * FROM your_table ORDER BY RANDOM();

XANO's DDQ tool is single-statement. So create two statements in that order and you're good.