I have looked at a number of examples of code on here to find a random item in a collection, however it seems to me that as wixdataquery limits the results to a default of 50 items, does that mean if you have more than 50 items in the collection you are really only randomising the first 50 with the examples I’ve seen. The examples I’ve seen show that you query the entire data collection and put it into an array, but I think it’s actually not the entire collection that comes into the array but just the first 50
I understand that you can increase this by using limit() however the max then is 1000.
Hypothetically, if you had more than 1000 items in the collection, what would you need to do to choose a random item from 5000 items?