CODEWITHSUNDEEP
node.jsmongodbmongoosemongodb-queryaggregation-framework
Varun Gopal K.P
Varun Gopal K.P

Reputation: 281

Reverse populate in mongoose

How can i reverse populate in mongo. I have 2 schema's

User:

var user_scheme = new mongoose.Schema({
  name:String,
  age:Number,
  roles:{
    type:mongoose.Schema.Types.ObjectId,
    ref:'Role'
  }
 });

Role:

var role_scheme = new mongoose.Schema({
  name:String,
});

Documents:

///user
{
"_id" : ObjectId("5bf9a19b01ce3e19b440aed8"),
"name" : "user1",
"age" : 22,
"roles" : ObjectId("5c0242621ab7b677e6b2e01e"),
"__v" : 0
}
 ///role
{
"_id" : ObjectId("5c0242621ab7b677e6b2e01e"),
"name" : "Admin"
}

Code:

User.find().populate('roles').exec(function (err, data) {
 res.json(data);
})

Here i can get roles under user, But how i get users under each role.

Upvotes: 12

Views: 8401

Answers (3)

younesbenallal
younesbenallal

Reputation: 131

The $lookup function by @Ashh was not working for me.

I used a more recent version :

$lookup: {
    from: 'users',
    localField: '_id',
    foreignField: 'organization',
    as: 'users'
}

Upvotes: 11

Ashh
Ashh

Reputation: 46441

You can use below $lookup aggregation

Role.aggregate([
  { "$match": { "name" : "Admin" }},
  { "$lookup": {
    "from": "users",
    "let": { "roleId": "$_id" },
    "pipeline": [
      { "$match": { "$expr": { "$eq": ["$roles", "$$roleId"] } } }
    ],
    "as": "users"
  }}
])

Upvotes: 9

amir
amir

Reputation: 2573

you can use mongoose-reverse-populate module.

Upvotes: 0

Related Questions