MongoDB Query a specific field in an array

Question

I have a MongoDB database structure that looks something like this.

{
    "peopleholder": {
        "people": [
            {
                "otherdata": "asdf",
                "name": "joe"
            },
            {
                "otherdata": "asdf",
                "name": "bob"
            }
        ]
    }
}

Now, I'm trying to construct a search query to select all people who have name "bob", right?

So, I've tried some things, looking at the $all suggestion, and come up with...

{
    "peopleholder": {
        "people": {
            "$all": [
                {
                    "name": "bob"
                }
            ]
        }
    }
}

I've also tried it with people just equal to {"name": "bob"}, as that appears to be shorthand.

mostafazh · Accepted Answer · 2018-11-07 23:33:56Z

1

This should do it:

{ "peopleholder.people.name": "bob"}

Source Mongodb docs

answered Nov 7, 2018 at 23:33

mostafazh

4,2071 gold badge23 silver badges26 bronze badges

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

2 Comments

Sam Clarke Over a year ago

Worked! Thank you!

Ryan Dobbs Over a year ago

Don't forget that this query will be case sensitive.

Collectives™ on Stack Overflow

MongoDB Query a specific field in an array

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