Get a count of total documents with MongoDB when using limit

by

Mongodb 3.4 has introduced $facet aggregation

which processes multiple aggregation pipelines within a single stage
on the same set of input documents.

Using $facet and $group you can find documents with $limit and can get total count.

You can use below aggregation in mongodb 3.4

db.collection.aggregate([
  { "$facet": {
    "totalData": [
      { "$match": { }},
      { "$skip": 10 },
      { "$limit": 10 }
    ],
    "totalCount": [
      { "$group": {
        "_id": null,
        "count": { "$sum": 1 }
      }}
    ]
  }}
])

Even you can use $count aggregation which has been introduced in mongodb 3.6.

You can use below aggregation in mongodb 3.6

db.collection.aggregate([
  { "$facet": {
    "totalData": [
      { "$match": { }},
      { "$skip": 10 },
      { "$limit": 10 }
    ],
    "totalCount": [
      { "$count": "count" }
    ]
  }}
])

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. $lookup on ObjectId’s in an array
  5. Return only matched sub-document elements within a nested array
  6. Converting string to date in mongodb
  7. Check if every element in array matches condition
  8. MongoDB nested lookup with 3 levels
  9. MongoDB Full and Partial Text Search
  10. Mongodb Join on _id field from String to ObjectId
  11. How to get back the Original document back after aggregation
  12. Mongo sort on a calculated condition
  13. MongoDB sort documents by array elements
  14. MongoDB lookup when foreign field is an array of objects
  15. MongoDB: Calculate dwell time between every status value change
  16. MongoDB: how to parse date in 3.6 mongoDb version?
  17. Search on multiple collections in MongoDB
  18. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  19. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  20. convert iso date to timestamp in mongo query
  21. Remove Duplicates from MongoDB
  22. Using $slice operator to get last element of array
  23. How to access overall document count during arithmetic aggregation expression
  24. Mongodb aggregation pipeline how to limit a group push
  25. count array occurrences across all documents with mongo
  26. $project in $lookup mongodb
  27. Return actual type of a field in MongoDB
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment