Find document with specific value from array within an array of subdocuments

Question

I want to find all documents that have, in an array of subdocuments, a value that matches anything within another array.

Documents

{
    storeName: String,
    location: String,
    inventory: [{
        itemName: String,
        price: Number,
        otherDetail: String,
    }]
}

Example array

let itemNames = ["chair", "bed", "table"];

I am using aggregate. I need to find all stores (documents) that have in the inventory any of the itemNames in the array.

FYI, if you answered/saw my other question, sorry, I got my data structure wrong and thought it would be better to just ask another question. — Lee Morgan
– Lee Morgan, Commented Jul 18, 2020 at 8:43

Kunal Mukherjee · Accepted Answer · 2020-07-18 09:56:51Z

1

Use a combination of $elemMatch operator along with $in to filter from your nested array.

var filter = {
    inventory: {
        $elemMatch: {
            itemName: {
                $in: ["chair", "bed", "table"]
            }
        }
    }
};

db.collection.find(filter);

With aggregate -

var pipeline = [
    {
        $match: {
            inventory: {
                $elemMatch: {
                    itemName: {
                        $in: ["chair", "bed", "table"]
                    }
                }
            }
        }
    }
];

db.collection.aggregate(pipeline);

edited Jul 18, 2020 at 9:56

answered Jul 18, 2020 at 9:06

Kunal Mukherjee

5,8733 gold badges29 silver badges55 bronze badges

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

2 Comments

Lee Morgan Over a year ago

The problem with this though, is that I am using aggregation and I cannot use $elemMatch with aggregation.

Kunal Mukherjee Over a year ago

@LeeMorgan updated my answer for usage with Aggregate

Collectives™ on Stack Overflow

Find document with specific value from array within an array of subdocuments

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related