Is there a way of fetching random documents from a collection?

In SQL, we have the RAND() function, is there an equivalent in Appwrite?

In my app, the user answers questions, which all have an Elo rating. I'm actually unfamiliar with how to choose which question next (matchmaking algorithms), but one way would be to choose a random value, I guess. If any of you guys have a better suggestion on how to tackle my specific problem, please let me know. Ideally, items would not repeat too much, and the range of question Elo should be similar to the user's.

Currently Nope.
Either you would have to know the total ammount of docuements in your collection then use a random function to genarate some random offset then query using those random offset.
Or you can fetch much docs
See how much docs are there
Then pick a random one.
Btw
There is a feature request of this issue
https://github.com/appwrite/appwrite/issues/5205
You could show intrest in this 🤷‍♂️

So
found a workaround
I forgot about this .
this requires 2 read requests

const randomQuery=async()=>{
    const numCheck= await databases.listDocuments(databaseId, collectionID,[
        Query.limit(1)
    ])
//the function above returns the total number of docs in that collection as a attribute

    const random= await databases.listDocuments(databaseId, collectionID,[
        Query.limit(1),
        Query.offset(Math.floor(Math.random() * numCheck.total)),
    ])
    return random.documents[0];
}

you can add more condition to the random like increasing the limit, adding extra queries to more filter etc.

Interesting! Thank you!

could you mark this as solved by added [SOLVED] before the title
so that in future if others search about this they can find it

Thank you for the workaround. But I would also would prefer a native appwrite function 😆