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
- general_unauthorized_scope
localhost oauth not working. general_unauthorized_scope error showing. { "message": "User (role: guests) missing scopes ([\"account\"])", "code": 401, ...
- I recently switched to TablesDb. When li...
olddb.list_documents( queries =[ Query.order_desc("timestamp"), Query.equal("isPosted",[False]) ] ) Above works fine and reruns documents But below don't return...
- Database error validating 'min' and 'max...
I keep seeing an error when I try to add a column to a database table within the AppWrite cloud UI. I also see this error when trying to create or update a reco...