count total number of elements inside an array in document - MongoDB

Question

I have a document related to the role or designations of employees. This is the document structure.

{
    "_id" : ObjectId("5660c2a5b6fcba2d47baa2d9"),
    "role_id" : 4,
    "role_title" : "Carpenter",
    "employees" : [ 
        {
            "$ref" : "employees",
            "$id" : 4,
            "$db" : "db_cw2"
        }, 
        {
            "$ref" : "employees",
            "$id" : 5,
            "$db" : "db_cw2"
        }
    ]
},

{
    "_id" : ObjectId("5660c2a5b6fcba2d47baa2d6"),
    "role_id" : 1,
    "role_title" : "Chief Executive",
    "employees" : [ 
        {
            "$ref" : "employees",
            "$id" : 1,
            "$db" : "db_cw2"
        }
    ]
}

I want to write a query to show or count total number of employees who are working as 'Carpenter' or simple words count number of elements in 'employees' field where 'role_title' : 'Carpenter'.

I have written this query but it shows total number of employees in all the documents of the collection.

db.employee_role.aggregate(
   {
        $project: { 
            count: { $size:"$employees" }
        }
   }
)

use $match in aggregation like this {"$match":{"role_title" : "Carpenter"}} and then project — Neo-coder
– Neo-coder, Commented Dec 14, 2015 at 13:34

Constantin Guay · Accepted Answer · 2015-12-14 13:33:27Z

7

You have to use $group instead:

db.employee_role.aggregate(
   {
        $group: {
            _id: "$role_title",
            total: { $sum: { $size:"$employees" } }
        }
   }
)

You group by role_title and then, you add the number of employees.

answered Dec 14, 2015 at 13:33

Constantin Guay

1,6642 gold badges16 silver badges27 bronze badges

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

Comments

Paulo Aquino · Accepted Answer · 2015-12-14 13:52:46Z

3

You could use this:

db.employee_role.aggregate(
  [
    {
      $match: { role_title: "Carpenter" }
    },
    {
      $group: {
        _id: "$role_title",
        total: { $sum: { $size: "$employees"} }
      }
    }
  ]
)

answered Dec 14, 2015 at 13:52

Paulo Aquino

9421 gold badge11 silver badges22 bronze badges

Collectives™ on Stack Overflow

count total number of elements inside an array in document - MongoDB

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related