Mongoose - aggreate to aggregated object?

Dmytro V 0
Viewed 8

Now i am using query like this:

const results = await User.aggregate([{$match: {"email": 'email here'}},{ $lookup:{ from: "businesses", localField: "businessId", foreignField: "_id", as: "businesses" } }]);

and i need to get other objects that belong to every single business, what is the way?

mongoose
1 Answers

Solved...

const qwery = await User.aggregate([
  {
    $match: { "email": 'email here' }
  },
  {  
    $lookup: { from: "businesses", localField: "businessId", foreignField: "_id", as: "business" }
  },
  {
    $lookup: {
      from: "superpages", localField: "_id", foreignField: "userId", as: "superpages",
      pipeline: [{ $lookup: { from: "subpages", localField: "_id", foreignField: "superPageId", as: "subpages" } }] ----------> THIS IS WHAT I NEEDED
    }
  },
  {
    $unwind: '$business'
  }
]);

All i needed is this:

pipeline: [{ $lookup: { from: "subpages", localField: "_id", foreignField: "superPageId", as: "subpages" } }]
Dmytro V0
Related