Group by objects in inner array (mongodb aggregation)

Question

I have docs like:

{
    "products": [
        {
           "uid": "aside-11kka-asdm12-asdjl"
           "price": 123,
           "count": 123
        }
    ]
}

And I want to group this into array of products, using aggregation (product uids can be repeated in another object)

Ashh · Accepted Answer · 2018-06-17 05:06:17Z

3

You need to $unwind first in order to group nested array

db.collection.aggregate([
  {
    "$unwind": "$products"
  },
  {
    $group: {
      "_id": "$products.uid",
      "count": {
        $push: "$products.count"
      },
      "price": {
        $push: "$products.price"
      }
    }
  }
])

answered Jun 17, 2018 at 5:06

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Group by objects in inner array (mongodb aggregation)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related