MongoDb Query on inner array

Question

I have a following document structure

Users:[{
    "name": "test",
    "leaveBalance": 20,
    "leaveHistory": [
       {
          type: "Leave",
          numberofDays:2,
          status:"Approved"
       },
       {
          type: "WFH",
          numberOfDays:1,
          status: "Approved"
       },
       {
           type: "Leave",
           numberOfDays:2,
           status: "Cancelled"
       }
     ]
}, 
{
 ...
}
]

I need a query to find the total number of days a person took leave from this collection. number of days of leave is considered only if status is Approved and leave type is "Leave". Is there a way in mongodb to query and find the number ?

shivshankar · Accepted Answer · 2017-12-12 05:28:30Z

1

try below

Users.aggregate([
{
    $match:{
        _id:user_id,
        "leaveHistory.type ":"Leave",
        "leaveHistory.status": "Approved"
    }
}, 
{
    unwind:"leaveHistory"
}, 
{
    $project:{
         $count: "numberofDays"
    }   
}
], (err, results)=>{
    console.log(err, results);
})

answered Dec 12, 2017 at 5:28

shivshankar

2,1351 gold badge20 silver badges28 bronze badges

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

3 Comments

sriram Over a year ago

Is this in mongo query syntax ?

shivshankar Over a year ago

yes, mongo have aggregation query framework , that have more methods read more docs.mongodb.com/v3.4/aggregation

sriram Over a year ago

The query doesnt seem to work for me. It returns as many values as present in the leaveHistory instead of sum of numberofDays per user.

Collectives™ on Stack Overflow

MongoDb Query on inner array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related