Mongodb sort inner array

by

You can do this by $unwinding the updates array, sorting the resulting docs by date, and then $grouping them back together on _id using the sorted order.

db.servers.aggregate(
    {$unwind: '$service.apps.updates'}, 
    {$sort: {'service.apps.updates.date': 1}}, 
    {$group: {_id: '$_id', 'updates': {$push: '$service.apps.updates'}}}, 
    {$project: {'service.apps.updates': '$updates'}})

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. MongoDB: Combine data from multiple collections into one..how?
  4. mongodb group values by multiple fields
  5. Conditional $sum in MongoDB
  6. Get a count of total documents with MongoDB when using limit
  7. mongodb count num of distinct values per field/key
  8. exclude fields in $lookup aggregation
  9. Mongodb Explain for Aggregation framework
  10. MongoDB aggregation comparison: group(), $group and MapReduce
  11. Add some kind of row number to a mongodb aggregate command / pipeline
  12. MongoDB group by array inner-elements
  13. Exception: can’t convert from BSON type EOO to Date
  14. Multiple Counts with single query in mongodb
  15. How to aggregate by year-month-day on a different timezone
  16. MongoDB sort documents by array elements
  17. Mongodb Aggregation Framework: Does $group use index?
  18. How to return array of string with mongodb aggregation
  19. How to return just the nested documents of an array from all documents
  20. Mongodb aggregation $group, restrict length of array
  21. Get n-th element of an array in MongoDB
  22. Geospatial $near within current document field value
  23. How do I rename fields when performing search/projection in MongoDB?
  24. Mongodb aggregation pipeline how to limit a group push
  25. MongoDB : aggregation framework : $match between fields
  26. mongodb aggregation framework match by nested documents
  27. Find documents whose array field contains at least n elements of a given array
  28. Generating a Structure for Aggregation
  29. $project in $lookup mongodb
  30. Return actual type of a field in MongoDB

Leave a Comment