MongoDB query with elemMatch for nested array data

Question

I have a document containing nested array data. I tried hopelessly to filter the data using $elemMatch but I cannot figure out why it is not working.

{
'id' : 1,
'name' : 'test',
'modules' : [
    {
        name: 'foo',
        mandatory: false,
        group: [
            {
                name: g1
            }]
    },
    {
        name: 'bar',
        mandatory: false,
        group: [
            {
                name: g2
            }]
    }]
}

I tried using this query:

db.test.find(
{
  modules: {
            $elemMatch: {
                 name: "foo",
            }
  }
}

But it keeps returning all the modules. If I use mandatory: true it returns nothing, which seems to indicates it works. Any idea what am I doing wrong? Thanks!

Querying is very easy but what about updates?

Pavel Nikolov
– Pavel Nikolov

2014-01-27 19:22:39 +00:00
Commented Jan 27, 2014 at 19:22 — Pavel Nikolov
– Pavel Nikolov, Commented Jan 27, 2014 at 19:22

JohnnyHK · Accepted Answer · 2013-12-11 17:32:37Z

19

Your query is simply returning all docs that contain a modules element where name == 'foo'. To use $elemMatch to filter the output, you need to use it in the projection argument of the find call instead of part of the query:

db.test.find({}, {modules: {$elemMatch: {name: 'foo'}}})

To combine both concepts, you can reference the index of the array element matched in the query with $:

db.test.find({modules: {$elemMatch: {name: 'foo'}}}, {'modules.$': 1})

Either way returns:

{
  "_id": ObjectId("..."),
  "modules": [
    {
      "name": "foo",
      "mandatory": false,
      "group": [
        {
          "name": "g1"
        }
      ]
    }
  ]
}

If you need other fields included in the output, add them to the projection object (e.g. name: 1).

edited Dec 11, 2013 at 17:32

answered Dec 11, 2013 at 17:27

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

1 Comment

Phil Over a year ago

Is it possible to chain the elemMatch? For example to filter on the "group" list on the name as well?

Collectives™ on Stack Overflow

MongoDB query with elemMatch for nested array data

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related