How can I randomly retrieve one document from a collection without fetching all documents?
- 0
- Databases
- Web

hey guys i made a appwrite database and i add my documents with relevant attributes in a collection, now is there any way to get randomly one of the document in a collection like without fetching all the documents id and then select one of the document. like it made the process slower if the no. of documents is many

This feature is not yet implemented

You might wanna upvote this issue

so i have to first retreive all the documents, then randomly get one, right?

Yes

sad

Also there's some work around

upvote done

Check this

Meaning you add another counter ID and randomly select it It's a bit tricky, but should work

also, what is the maximum limit to get documents?, its 100?

Now you can go up to 5K

ok 5k will be enough for me

thanks
Recommended threads
- Appwrite documents and Swift codable
The object I use to create a document is different than the object I receive when I list documents. Do I create an object that’s used to create a document and a...
- How To Send Email Verification From Serv...
How can I send email verification from server action or component after sign up in next.js ? Is there any way ?
- x-appwrite-user-jwt missing
Even for logged in users I can't see "x-appwrite-user-jwt" or "x-appwrite-user-id" in headers of an appwrite function. I'm trying to send "x-appwrite-user-id" m...
