Multiple Counts with single query in mongodb

by

You can try below $facet aggregation

$count aggregation will always give you the counts for only single matching ($match) condition. So you need to further divide your each count into multiple section and that’s what the $facet provides by processes multiple aggregation pipelines within a single stage on the same set of input documents.

db.collection.aggregate([
  { "$facet": {
    "Total": [
      { "$match" : { "ReleaseDate": { "$exists": true }}},
      { "$count": "Total" },
    ],
    "Released": [
      { "$match" : {"ReleaseDate": { "$exists": true, "$nin": [""] }}},
      { "$count": "Released" }
    ],
    "Unreleased": [
      { "$match" : {"ReleaseDate": { "$exists": true, "$in": [""] }}},
      { "$count": "Unreleased" }
    ]
  }},
  { "$project": {
    "Total": { "$arrayElemAt": ["$Total.Total", 0] },
    "Released": { "$arrayElemAt": ["$Released.Released", 0] },
    "Unreleased": { "$arrayElemAt": ["$Unreleased.Unreleased", 0] }
  }}
])

Output

[{
    "Total": 3,
    "Released": 2,
    "Unreleased": 1
}]

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Does MongoDB’s $in clause guarantee order
  3. $lookup on ObjectId’s in an array
  4. Moongoose aggregate $match does not match id’s
  5. Find in Double Nested Array MongoDB
  6. Converting string to date in mongodb
  7. Check if every element in array matches condition
  8. MongoDB nested lookup with 3 levels
  9. Get a count of total documents with MongoDB when using limit
  10. Include all existing fields and add new fields to document
  11. MongoDB Full and Partial Text Search
  12. Matching ObjectId to String for $graphLookup
  13. mongodb count num of distinct values per field/key
  14. MongoDB aggregation comparison: group(), $group and MapReduce
  15. Mongodb aggregation lookup with conditions
  16. How to get back the Original document back after aggregation
  17. MongoDB group by array inner-elements
  18. Mongo sort on a calculated condition
  19. MongoDB lookup when foreign field is an array of objects
  20. MongoDB: Calculate dwell time between every status value change
  21. Search on multiple collections in MongoDB
  22. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  23. Get n-th element of an array in MongoDB
  24. How to access overall document count during arithmetic aggregation expression
  25. How do I rename fields when performing search/projection in MongoDB?
  26. mongodb aggregation framework match by nested documents
  27. count array occurrences across all documents with mongo
  28. $project in $lookup mongodb
  29. Mongodb concat int and string
  30. Return actual type of a field in MongoDB

Leave a Comment