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
- Skip total counts crash the query
Hello, When adding the total parameter (either true, the default, or false) to the listRows function, it raises the following error: `type 'bool' is not a sub...
- Relationships and Realtime
Since now Relationship attributes are only returned when explicitly queried, how does this change reflect in Realtime? If a listener is listening to a row from ...
- Rate límit reset
I've made an error in the code by not setting a limit on how much rows should i get per request because i was working with a small db for testing. Last night Iv...