is there a way to use countDocuments() on a resolved query mongoose?

Question

I have this code

async findAll(query: SharedPreferences, req): Promise<IVehicle[]> {
const vehicles = this.vehicleModel
  .find({
    ...req.searchObj,
    ...req.dateQr,
  })
  .sort({ [query.sort]: query.orderBy === "desc" ? -1 : 1 })
  .skip(req.skip)
  .populate(["owner", "branch"]);

const total = vehicles;

vehicles.limit(+query.limit);

const response: any = {
  result: await vehicles,
  // count: total.countDocuments(), // this doesnt work here since vehicles already been awaited
  limit: +query.limit,
  page: +query.page,
};

return response;

}

what I'm trying to do is to get the total count of the vehicle documents without the (limit) query and also the vehicles documents (the array result of find()) with one query.

I need to separate the limit() so it doesn't count the vehicles while they are limited in order to get the actual total, but when you await the vehicles you cant access the .countDocuments() anymore since the promise is resolved.

I copied the vehicles into a new total variable which I thought will be different, but since it addresses the same query, it's no use. is there a way to implement this without making 2 queries. thanks

@IsiakaLukmanBamidele that wouldnt work because the query is not yet executed to get the length of it. — Lhon Rafaat Mohammed, Jan 20 '22 at 11:31

score 0 · Answer 1 · answered Jan 20 '22 at 11:14

0

You can use count operator on vehicles.

async findAll(query: SharedPreferences, req): Promise<IVehicle[]> {
const vehicles = this.vehicleModel
  .find({
    ...req.searchObj,
    ...req.dateQr,
  })
  .sort({ [query.sort]: query.orderBy === "desc" ? -1 : 1 })
  .skip(req.skip)
  .populate(["owner", "branch"]);

vehicles.limit(+query.limit);

const response: any = {
  result: await vehicles,
  count: await vehicles.count(),
  limit: +query.limit,
  page: +query.page,
};

return response;

You can check more ways here to achieve the same if the above doesn't work.

answered Jan 20 '22 at 11:14

Apoorva Chikara

8,277
3
20
35

nope , didnt work, because the vehicles is already executed when result : await vehicles so can't do await vehicles.count() anymore – Lhon Rafaat Mohammed Jan 20 '22 at 11:32
Have you checked the link I shared? – Apoorva Chikara Jan 20 '22 at 12:05
yes, I fixed it, but actually none of them referenced the simple solution which is using clone() to make a copy of the query then get the the length of that copy while the .limit() is not executed, ill post it as an answer so maybe it will be useful for other ppl too. – Lhon Rafaat Mohammed Jan 20 '22 at 12:11
or I think .clone() is new, from version 6.0.13 – Lhon Rafaat Mohammed Jan 20 '22 at 12:17

score 0 · Answer 2 · answered Jan 20 '22 at 12:12

So this worked for me

async findAll(query: SharedPreferences, req): Promise<IVehicle[]> {
const vehicles = this.vehicleModel
  .find({
    ...req.searchObj,
    ...req.dateQr,
  })
  .sort({ [query.sort]: query.orderBy === "desc" ? -1 : 1 })
  .skip(req.skip)
  .populate(["owner", "branch"]);

const total = await vehicles.clone().count();

vehicles.limit(+query.limit);

const response: any = {
  count: total,
  result: await vehicles,
  limit: +query.limit,
  page: +query.page,
};

return response;

}

you can use .clone() to save a copy of the query, and then get the count of that before the .limit() is executed, so this will return the vehicles, and the total count without the limit.

is there a way to use countDocuments() on a resolved query mongoose?

2 Answers2