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
- I can't UNPAUSE my project with the free...
I received an email notifying me that my project had been paused due to inactivity, and the email included a link to "Restore project." However, that button red...
- How to bypass the rate limit on the back...
Once a month my app has a ton of usage and I always run into the Too many requests 429 error. I am trying to optimize the queues and jobs to manage that, but a...
- 401 - Project not accessible in this reg...
Hi Appwrite team, I’m experiencing a Cloud Console issue with my NYC region project. Problem: - Some Console pages return: “401 - Project is not accessible ...