[SOLVED] how to get all documents and remove 25 docs limit

how to get all documents and remove 25 docs limit using client sdk in flutter.

Pass, eg, Query.limit(100) to get 100 documents. The max is 5000

but i don't want any limit

like firestore allows to get all docs

can i query all docs in cloud function using server api?

Appwrite does not have that option. You could build a loop that’ll continue fetching the next, say 1000 Documents or something until there are no more left to return.

My understanding is that Firestore is a very different concept to Appwrite Databases (I’ve never actually used Firebase, so I can’t speak for personal experience, here).

because i need to query all to calculate the total amount from each doc and save it somewhere so i can show it as stats on admin dashboard of my app.

Same limits apply to Server SDKs.

in front end app i can use pagination for both performace and loading less docs means using less bandwidth unless user requests more docs.

I don’t think you’d be able to do that in a Function anyway, even if you could pull more than 5000 records - it would take far to long to do - there’s no way you could do it in within the Function timeout limits.

then how can handle this kind of requirement? maybe, i can create cloud function which triggers on create, update, delete docs, and adds/subtracts the amount from total amount and updates it?

[SOLVED] how to get all documents and remove 25 docs limit