Get multiple counts based on multiple conditions in MongoDB

Question

I wanna run multiple queries to get the count on a MongoDB collection. Like, I wanna run a query to find out pending status users and completed status users. Something like this, is there a way to write these two conditions in a query/aggregation and get the separate results in MongoDB?

My Requirement is,

I need to get the count of the user of status pending, completed and open for Today, Yesterday, last week and last Month.

I need different status count like this,

{
 "today": {
    "pending": 10,
    "completed": 13,
    "open": 5
  },
  "yesterday": {
    "pending": 10,
    "completed": 13,
    "open": 5
  },
  "lastWeek": {
    "pending": 10,
    "completed": 13,
    "open": 5
  },
  "lastMonth": {
    "pending": 10,
    "completed": 13,
    "open": 5
  }
}

Nicolas · Accepted Answer · 2018-03-26 10:10:34Z

5

You can use the aggregation $group stage for that:

db.Collection.aggregate([
    {$project: {
        // If your pending/completed field is set to 1 or true
        pending: {$cond: [{$eq: ["$pending", 1 /* or true */]}, 1, 0]},
        completed: {$cond: [{$eq: ["$completed", 1 /* or true */]}, 1, 0]}
    }},
    {$group: {
        _id: //what you want,
        pending: {$sum: "$pending"},
        completed: {$sum: "$completed"}
    }}
]);

answered Mar 26, 2018 at 10:10

Nicolas

4575 silver badges15 bronze badges

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

2 Comments

NitinD Over a year ago

I have updated the question. I think your query is correct but to acquire the above result, I will need to query four times for four timestamps. Is there a way to get the above result in one query?

Nicolas Over a year ago

I don't know if there is a solution, I never group by date with mongo, try to $match in term of your need

Collectives™ on Stack Overflow

Get multiple counts based on multiple conditions in MongoDB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related