the default it 25 records, how to get more or less?
I tried this code but it didn't work:
TypeScript
"use server";
const sdk = require("node-appwrite");
const client = new sdk.Client()
.setEndpoint(process.env.NEXT_PUBLIC_CMS_ENDPOINT)
.setProject(process.env.NEXT_PUBLIC_CMS_PROJECT)
.setKey(process.env.CMS_APIKEY);
const databases = new sdk.Databases(client);
export async function getReportData(documentID) {
const limit = 2;
let offset = 0;
let allResults = [];
let result;
try {
do {
result = await databases.listDocuments(
process.env.DB_ID,
process.env.NEXT_PUBLIC_VNG_CLAIMS,
[
sdk.Query.limit(limit),
sdk.Query.offset(offset)
]
);
allResults = allResults.concat(result.documents);
offset += limit;
} while (result.documents.length === limit);
return allResults;
} catch (e) {
throw new Error(e.message);
}
}
TL;DR
To adjust the number of records retrieved, you can set the limit in the code snippet provided. Update the 'limit' variable to the desired number of records.Recommended threads
- Quota not resetting
hi, im using appwrite's free tier plani hit my read limts last month and the billing cycle said it would reset on june 4th but that is today, the billing cycle ...
- Student plan issue
I am using GitHub student plan, I even got access to appwrite's mock phone number. but when I try to use it, it says the phone number limit has reached
- DB Relational Table Request
Hi, I'd like to suggest a rewording of the relationships between tables. - Current wording: storeOperatingDays can contain one storeId ...