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
- Any example for using Appwrite with Verc...
Can not find an example on this.
- AppwriteException Network request failed...
I'm watching a react native / expo tutorila that uses Appwrite as it's backend for its database. So, in this tutorial, there is implementing the seed functional...
- createDocument not returning result
when making a createDocument call, I am not getting the object created. The DB is updated properly. Is this expected behavior?
