Lookup & populate objects in array

[James_N_A2 (James N/A)]

Hey,

Thanks for the reply! I’ve created a new post here:

How to lookup and merge documents based on a nested array of ObjectIds

Hi, I’m still getting to grips with the aggregation pipeline and need a bit of help understanding how I would piece together the following data: I have a collection of ‘users’ that has a nested document called ‘roles’ within it. A user can belong to one or many ‘schools’ and with each school have a different set of ‘roles’. Here’s how I’ve structured the data: User: name, email, schools: [ { roles: ['admin', 'user'], schoolId: ObjectId(...) } ] A school looks like this: _id, …

Hopefully, that shines some light on what I’m trying to do.

J