Add some kind of row number to a mongodb aggregate command / pipeline

by

Not sure about the performance in big queries, but this is at least an option.

You can add your results to an array by grouping/pushing and then unwind with includeArrayIndex like this:

[
  {$match: {author: {$ne: 1}}},
  {$limit: 10000},
  {$group: {
    _id: 1,
    book: {$push: {title: '$title', author: '$author', copies: '$copies'}}
  }},
  {$unwind: {path: '$book', includeArrayIndex: 'rownum'}},
  {$project: {
    author: '$book.author',
    title: '$book.title',
    copies: '$book.copies',
    rownum: 1
  }}
]

Now, if your database contains a big amount of records, and you intend to paginate, you can use the $skip stage and then $limit 10 or 20 or whatever you want to display per page, and just add the number from the $skip stage to your rownum and you’ll get the real position without having to push all your results to enumerate them.

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Get names of all keys in the collection
  3. How to filter array in subdocument with MongoDB [duplicate]
  4. MongoDB: Combine data from multiple collections into one..how?
  5. Moongoose aggregate $match does not match id’s
  6. Find in Double Nested Array MongoDB
  7. Multiple join conditions using the $lookup operator
  8. Conditional $sum in MongoDB
  9. Check if every element in array matches condition
  10. Get a count of total documents with MongoDB when using limit
  11. Include all existing fields and add new fields to document
  12. Matching ObjectId to String for $graphLookup
  13. mongodb count num of distinct values per field/key
  14. exclude fields in $lookup aggregation
  15. MongoDB aggregation comparison: group(), $group and MapReduce
  16. MongoDB group by array inner-elements
  17. Multiple Counts with single query in mongodb
  18. MongoDB sort documents by array elements
  19. How to return array of string with mongodb aggregation
  20. How to return just the nested documents of an array from all documents
  21. MongoDB lookup when foreign field is an array of objects
  22. Mongodb aggregation $group, restrict length of array
  23. Get n-th element of an array in MongoDB
  24. Geospatial $near within current document field value
  25. How do I rename fields when performing search/projection in MongoDB?
  26. Mongodb aggregation pipeline how to limit a group push
  27. mongodb aggregation framework match by nested documents
  28. Mongodb concat int and string
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment