How to get size of array nested in another array with mongoose aggregate

Question

I have document in my collection

{
  _id: "8sd7f8s7df8s7df8"
  projects: [
    {
      name: inbox,
      tasks: [
        { name: 'task1' }
        { name: 'task2' }
        { name: 'task3' }
      ]
    }
  ]
}

I want to find document by _id and get number of tasks inside each project

I wrote this aggregate code but it's getting me number of tasks across all projects rather then size of each tasks array

User.aggregate([
  { $match: { _id: Mongoose.Types.ObjectId(userId)}},
  { $project: {
    _id: 0,
    'projects.name': 1,
    'projects.count': { $size: '$projects.tasks' }
  }}
])

How I should change this to get correct value?

chridam · Accepted Answer · 2016-04-23 15:16:45Z

3

Try doing an $unwind first before the $project pipeline:

User.aggregate([
    { "$match": { "_id": userId } },
    { "$unwind": "$projects" },
    { 
        "$project": {
            "_id": 0,
            "projects.name": 1,
            "projects.count": { "$size": "$projects.tasks" }
        }
    }
]).exec(callback);

answered Apr 23, 2016 at 15:16

chridam

104k26 gold badges246 silver badges243 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

arthurr Over a year ago

Thanks @chridam, that helps.

Collectives™ on Stack Overflow

How to get size of array nested in another array with mongoose aggregate

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related