How to query nested arrays in mongodb from command line

Question

I have some data structured like this in a mongo collection:

{ "list" : [ { "update_time" : NumberLong(1426690563), "provider" : NumberLong(4) } ] }

What I would like to do is query for all of the entries where the list includes a provider value of 4.

If it helps, all of the list arrays contain only one element.

What I am trying right now is this:

db.collection.find(
    {
      list: {
              provider: 4
            }
    }
)

This does not work though, and always returns an empty set

This is the solution

johncorser
– johncorser

2015-03-18 15:33:37 +00:00
Commented Mar 18, 2015 at 15:33 — johncorser
– johncorser, Commented Mar 18, 2015 at 15:33

chridam · Accepted Answer · 2015-03-18 15:42:38Z

1

Use the dot notation i.e. concatenate the name of the field that contains the array, with a dot (.) and the name of the field in the embedded document and use that as your query:

db.collection.find({"list.provider": 4})

You can also use the $elemMatch operator to specify multiple criteria on an array of embedded documents such that at least one embedded document satisfies all the specified criteria:

db.collection.find({
    list: {
        $elemMatch: {
            provider: 4
        }
    }
})

edited Mar 18, 2015 at 15:42

answered Mar 18, 2015 at 15:36

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Collectives™ on Stack Overflow

How to query nested arrays in mongodb from command line

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