Aggregating nested arrays in mongodb

Question

I know I can use $in to match an element in an array, but what if the array is nested? Like so:

{
    "_id": ObjectId("somethingsomething"),
    "supermarkets": [
        {
            "groceries": [
                {
                    "groceryType": "banana",
                    "groceryStockDate": "12345678",
                    "groceryAmount": 12
                },
                {
                    "groceryType": "cabbage",
                    "groceryStockDate": "313512",
                    "groceryAmount": 53
                },
                {
                    "groceryType": "strawberry",
                    "groceryStockDate": "51362",
                    "groceryAmount": 52
                }
            ]
        },
        {
            "groceries": [
                {
                    "groceryType": "banana",
                    "groceryStockDate": "31321",
                    "groceryAmount": 52
                },
                {
                    "groceryType": "banana",
                    "groceryStockDate": "532451",
                    "groceryAmount": 73
                },
                {
                    "groceryType": "cucumber",
                    "groceryStockDate": "123",
                    "groceryAmount": 12
                }
            ]
        }
    ]
}

Here, I want to get every object with groceryType: banana, so the end result should be something like

[
    {
        "groceryType": "banana",
        "groceryStockDate": "12345678",
        "groceryAmount": 12
    },
    {
        "groceryType": "banana",
        "groceryStockDate": "31321",
        "groceryAmount": 52
    },
    {
        "groceryType": "banana",
        "groceryStockDate": "532451",
        "groceryAmount": 73
    }
]

I specifically want to do this with aggregate, as I need to pass this through more stages later.

Tushar Gupta - curioustushar · Accepted Answer · 2021-03-31 12:39:17Z

1

Demo - https://mongoplayground.net/p/ayerR4qQMoI

Use $unwind on supermarkets and supermarkets.groceries to get individuals documents and use $match to filter the data and $project to get correct shape.

db.collection.aggregate({
  $unwind: "$supermarkets"
},
{
  $unwind: "$supermarkets.groceries"
},
{
  $match: {
    "supermarkets.groceries.groceryType": "banana"
  }
},
{
  $project: {
    _id: 0,
    groceries: "$supermarkets.groceries"
  }
})

answered Mar 31, 2021 at 12:39

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

Aggregating nested arrays in mongodb

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related