Question 117743 in Mongodb Question posted in
The official documentation can be found here.

Exclude certain attributes from object using the populate from mongodb using aggregate

I want to exclude for example email and address using populate() function from mongodb, just get the name from it:

Example:

const results = await Seller.aggregate(aggregatePipeline).exec();
const sellers = await Seller.populate(results, { path: "user" });

When populating the user instead of having:

...
user: {
    email: "[email protected]",
    address:{},
    name: "name"
}

I want to only have (exclude certain data from the path):

...
user: {
   name: "name"
}
Tags:

2

Answers


  1. 0

    You can do either,

    const sellers = await Seller.populate(results, { path: "user", select: '- 
email -address'  });

    or

    const sellers = await Seller.populate(results, { path: "user", select: 
'name'  });
    Login or Signup to reply.
  2. 0

    As i understand mongoose documentation https://mongoosejs.com/docs/populate.html, populate as $lookup is use to resolve a relation with other collection.

    MongoDB has the join-like $lookup aggregation operator in versions >= 3.2. Mongoose has a more powerful alternative called populate(), which lets you reference documents in other collections.

    In your case, you don’t need to resolve a field with an other collection. You already have the final data you target . You could use $project at the end of your pipeline aggregation to keep only name field, like :

    { $project: { name:1 } }

    Let me know if i helped you.

    Edit :

    I read too fast, if you have this data res after the populate and not after the aggreg, you may select your final field, like is said
    here https://stackoverflow.com/a/72481338/16205278

    user: {
    email: "[email protected]",
    address:{},
    name: "name"
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search