Back

how to set the limit of results?

  • 0
  • React Native
Alex Bourg
11 Jun, 2024, 10:55

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.
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more