How to filter array in subdocument with MongoDB [duplicate]

by

Using aggregate is the right approach, but you need to $unwind the list array before applying the $match so that you can filter individual elements and then use $group to put it back together:

db.test.aggregate([
    { $match: {_id: ObjectId("512e28984815cbfcb21646a7")}},
    { $unwind: '$list'},
    { $match: {'list.a': {$gt: 3}}},
    { $group: {_id: '$_id', list: {$push: '$list.a'}}}
])

outputs:

{
  "result": [
    {
      "_id": ObjectId("512e28984815cbfcb21646a7"),
      "list": [
        4,
        5
      ]
    }
  ],
  "ok": 1
}

MongoDB 3.2 Update

Starting with the 3.2 release, you can use the new $filter aggregation operator to do this more efficiently by only including the list elements you want during a $project:

db.test.aggregate([
    { $match: {_id: ObjectId("512e28984815cbfcb21646a7")}},
    { $project: {
        list: {$filter: {
            input: '$list',
            as: 'item',
            cond: {$gt: ['$$item.a', 3]}
        }}
    }}
])

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Get names of all keys in the collection
  3. Moongoose aggregate $match does not match id’s
  4. Find in Double Nested Array MongoDB
  5. Conditional $sum in MongoDB
  6. Check if every element in array matches condition
  7. Get a count of total documents with MongoDB when using limit
  8. Include all existing fields and add new fields to document
  9. Matching ObjectId to String for $graphLookup
  10. mongodb count num of distinct values per field/key
  11. exclude fields in $lookup aggregation
  12. MongoDB aggregation comparison: group(), $group and MapReduce
  13. Mongodb aggregation lookup with conditions
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. MongoDB group by array inner-elements
  16. Multiple Counts with single query in mongodb
  17. MongoDB sort documents by array elements
  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 lookup when foreign field is an array of objects
  21. Mongodb aggregation $group, restrict length of array
  22. Get n-th element of an array in MongoDB
  23. Geospatial $near within current document field value
  24. How do I rename fields when performing search/projection in MongoDB?
  25. Mongodb aggregation pipeline how to limit a group push
  26. mongodb aggregation framework match by nested documents
  27. $project in $lookup mongodb
  28. Return actual type of a field in MongoDB
  29. Mongodb, aggregate query with $lookup
  30. Return the last “true” value for each group

Leave a Comment