Model Random Ordering
Developer Preview
Is it possible to order model collection results randomly? I’m not seeing anything in the documentation and looking through the code it is not immediately apparent how to do it.
I’m on my mobile at the moment, but think the simplest way would be to shuffle() the asArray of your Collection result.
But that doesn’t work so well if you have a limit on the query and want random results from the database, right?
Correct, sounds like a good feature request. In the meantime, you could do it with two queries to help it have a low memory footprint. The first using ->fields() so it doesn’t return a full data set. Then shuffle() the asArray() result, chop off however many you need, and use those primary keys as filters in a second query to get all of your data.
Alright, I’ve got a pseudo random thing going on using something like the method you described. Do I need to put this feature request in somewhere like the feature request forum?
No need, I’ve got it marked for internal discussion.
Good deal!