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
- My collection is not updating after csv ...
- phantom relationships appear on parent c...
i have this bug were my past deleted collection apears as relationship to my parent collection. when i try to delete that relationship from parent it gives me e...
- Attribute stuck on proccessing
i tried creating a new attribute butits stuck on proccessing,i did a hard refresh,cleared cache everything but still stuck on proccessing,also in my functions w...
