MongoDB Aggregation: How to get total records count?

by

Since v.3.4 (i think) MongoDB has now a new aggregation pipeline operator named ‘facet‘ which in their own words:

Processes multiple aggregation pipelines within a single stage on the same set of input documents. Each sub-pipeline has its own field in the output document where its results are stored as an array of documents.

In this particular case, this means that one can do something like this:

$result = $collection->aggregate([
  { ...execute queries, group, sort... },
  { ...execute queries, group, sort... },
  { ...execute queries, group, sort... },
  {
    $facet: {
      paginatedResults: [{ $skip: skipPage }, { $limit: perPage }],
      totalCount: [
        {
          $count: 'count'
        }
      ]
    }
  }
]);

The result will be (with for ex 100 total results):

[
  {
    "paginatedResults":[{...},{...},{...}, ...],
    "totalCount":[{"count":100}]
  }
]

More Related Contents:

  1. MongoDB first time user setup [closed]
  2. How to execute mongo commands through shell scripts?
  3. pushing object into array schema in Mongoose
  4. Performing regex queries with PyMongo
  5. Check if every element in array matches condition
  6. What is the default database path for MongoDB?
  7. Updating nested arrays in mongoDB via mongo shell [duplicate]
  8. How can I get a random record from MongoDB?
  9. MongoDB vs. Cassandra [closed]
  10. Select Max() with “group by” in mongodb
  11. Rounding to 2 decimal places using MongoDB aggregation framework
  12. How to print out more than 20 items (documents) in MongoDB’s shell?
  13. MongoDB – Update or Insert object in array
  14. Updating the path ‘x’ would create a conflict at ‘x’
  15. Why does direction of index matter in MongoDB?
  16. How can I update multiple documents in mongoose?
  17. MongoDB update with condition
  18. mongodb get distinct records
  19. Matching an array field which contains any combination of the provided array in MongoDB
  20. MongoDB lookup when foreign field is an array of objects
  21. Get the latest record from mongodb collection
  22. Collision probability of ObjectId vs UUID in a large distributed system
  23. $skip and $limit in aggregation framework
  24. Read-only file system when attempting mkdir /data/db on Mac [closed]
  25. Mongodb Aggregation Framework | Group over multiple values?
  26. How does MongoDB order their docs in one collection? [duplicate]
  27. How to stop mongo DB in one command
  28. MongoDB: how to count number of keys in a document?
  29. Aggregation with update in mongoDB
  30. Query for a field in an object in array with Mongo?

Leave a Comment