I have the following function ```Future<models.DocumentList> returnAllTheTanks() async {
List<String>? tankQuery = [
Query.equal("facility_fk", facilityFk),
];
return await _manageSession.queryDocument(cTankCollection, tankQuery);
} , which is called by models.DocumentList theTankList = await returnAllTheTanks();```I get back a list whose total is 27 items which corresponds to the actual number in the web console, but when I iterate through them, I find the last two documents never make into the list. Why might this be?
Similiar issue which will help: https://discord.com/channels/564160730845151244/1136628130707157024
Instead of using a hardcoded value for the limit, consider using pagination.
Pagination reference: https://appwrite.io/docs/databases-pagination
@mauricev did this fix your issue?
Yes
thank you
[SOLVED] why is appwrite skipping documents?
Recommended threads
- IMPORTANT! SOC-2 Request Failing
Issue requesting SOC-2. If tried other/private browser as well as filling in optional fields.
- Can you suppress row $meta data?
When using listRows with a 'select' query to limit the response [for performance], I'm still getting extra columns (eg. `$id`, `$sequence`, `$createdAt`, `$upda...
- CLI - get Database Totals
Is there a way with the Appwrite CLI to get table row totals (count)❓