M ZeeshanM
Convex Community17mo ago
76 replies
M Zeeshan

Retrieve Total Document Count Before Pagination

I want to retrieve the total number of documents found before pagination takes place. However, I tried the following code and encountered an error.

error:
Uncaught Error: A query can only be chained once and can't be chained after iteration begins.

code:
let queryBuilder = ctx.db.query('skills');

if (title) {
      // @ts-ignore
      queryBuilder = queryBuilder.withSearchIndex('title', (q) =>
        q.search('title', title),
      );
    }

    queryBuilder = queryBuilder.filter((q) =>
      q.eq(q.field('isDeleted'), false),
    );

    // some code //

    if (type !== undefined) {
      queryBuilder = queryBuilder.filter((q) =>
        q.eq(q.field('type'), type),
      );
    }

    const totalFound = await queryBuilder.collect();
    const results = await queryBuilder.paginate(args.paginationOpts);
Was this page helpful?