Find by array of Ids not working with Mongoose aggregate method

Question

I would like to use the aggregate in mongoose to get documents that match the ids in the array. The array contains mongoose object ids. It is returning an empty array. Here is my code:

let isSelectedTrips = ["******", "*****"]// this actually contains trip ids.

 const me = await Trips.aggregate([
        {
          $match: { isPublished: true, _id: { $in: isSelectedTrips } },
        },
        {
          $facet: {
            getTrips: [{ $skip: skip }, { $limit: Number(searchlimit) }],
            totalDocumentSize: [{ $count: "count" }],
          },
        },
      ]);
      trips = me[0].getTrips;
      totalDocumentSize = me[0].totalDocumentSize[0]?.count || 0;

When I rewrote the conde using find method and used the same $in method, it worked. That means that I may not be doing it properly with the aggregate method. I need to use the aggregate method to also get the total document size before applying limit. I am doing this in Node.js. Here is the version that worked:

  const me = await Trips.find({ _id: { $in: isSelectedTrips }, isPublished: true, });
      trips = me;
      totalDocumentSize = 3;

How do I get the aggregate method to use array of ids to find matching documents?

Hamed Jimoh · Accepted Answer · 2025-02-20 19:30:43Z

0

You may want to wrap the isSelectedTrips in a mongoose ObjectId instance

let isSelectedTrips = ["******", "*****"]// this actually contains trip ids.

const objectIds = isSelectedTrips.map(id => mongoose.Types.ObjectId(id));

 const me = await Trips.aggregate([
        {
          $match: { isPublished: true, _id: { $in: objectIds } },
        },
        {
          $facet: {
            getTrips: [{ $skip: skip }, { $limit: Number(searchlimit) }],
            totalDocumentSize: [{ $count: "count" }],
          },
        },
      ]);
      trips = me[0].getTrips;
      totalDocumentSize = me[0].totalDocumentSize[0]?.count || 0;

edited Feb 20 at 19:30

answered Feb 20 at 19:05

Hamed Jimoh

1,4662 gold badges10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Find by array of Ids not working with Mongoose aggregate method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related