Mongoose 'reversed' population, i.e. populating a parent object based on the reference defined in child schema
If you want to get a ProjectGroup object, which contains all the projects under that group. You can use Populate Virtuals. (Mongoose version > 4.5.0)
create a virtual schema in your schema file.
ProjectGroupSchema.virtual('projects', { ref: 'Project', // The model to use localField: 'projectGroupId', // Your local field, like a `FOREIGN KEY` in RDS foreignField: 'group', // Your foreign field which `localField` linked to. Like `REFERENCES` in RDS // If `justOne` is true, 'members' will be a single doc as opposed to // an array. `justOne` is false by default. justOne: false});
and query in following:
ProjectGroup.find().populate('projects').exec(function(error, results) { /* `results.projects` is now an array of instances of `Project` */});
If you cannot see virtuals part, plese set { toJSON: { virtuals: true } }
to your model.
var ProjectGroupSchema = new Schema({ projectGroupId : String, title : String}, { toJSON: { virtuals: true } });
You can achieve this by using aggregate function. First group projects by "projectGroup" and then populate result.
project.aggregate([ {$group: {_id: "$group", projects: {$push: "$$ROOT"}}}], function(err,results) { user.populate( results, { "path": "projects.subscribers" }, function(err,results) { if (err) console.log(err); res.send(results); });});