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
- Auto Updating Backend & Auth via Appwrit...
<@870607367597850624> Hey everyone 👋 I wanted to ask to ask for a friend, he’s asking if Appwrite be used in a similar way to Supabase when integrated with AI ...
- execution failed
When executing an appwrite function, I'm getting a 500 error, but I don't see it in executions. This issue appeared today. Here's the appwrite function ID: 68b4...
- Is Database Operators available in Cloud...
Is it possible to do the above?