Mongodb aggregation pipeline how to limit a group push

by

Suppose the bottom left coordinates and the upper right coordinates are respectively [0, 0] and [100, 100]. From MongoDB 3.2 you can use the $slice operator to return a subset of an array which is what you want.

db.collection.aggregate([
    { "$match": { 
        "loc": { 
            "$geoWithin":  { 
                "$box": [ 
                    [0, 0], 
                    [100, 100]
                ]
            }
        }}
    }},
    { "$group": { 
        "_id": "$name",
        "submitted": { "$max": "$submitted" }, 
        "preview": { "$first": "$preview" }
        "locs": { "$push": "$loc" }
    }}, 
    { "$project": { 
        "locs": { "$slice": [ "$locs", 5 ] },
        "preview": 1,
        "submitted": 1
    }},
    { "$limit": 10 }
])

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. Matching ObjectId to String for $graphLookup
  11. Mongodb Join on _id field from String to ObjectId
  12. Mongodb aggregation lookup with conditions
  13. How to get back the Original document back after aggregation
  14. Mongo sort on a calculated condition
  15. MongoDB lookup when foreign field is an array of objects
  16. MongoDB: Calculate dwell time between every status value change
  17. MongoDB: how to parse date in 3.6 mongoDb version?
  18. Search on multiple collections in MongoDB
  19. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  20. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  21. convert iso date to timestamp in mongo query
  22. Remove Duplicates from MongoDB
  23. Using $slice operator to get last element of array
  24. How to access overall document count during arithmetic aggregation expression
  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