Mongo db - Querying documents using nested field (nested array and objects)

Question

{
  "_id":"12345",
  "model":{
     "T":0,
     "serviceTask":[
        {
          "_id":"6789",
           "obj":{
             "params" :{
                "action": "getEmployeeData",
                "employeeId":"123"
             },
             "url":"www.test.com",
             "var":"test",
           },
           "opp":100
        }
     ]
  }
}

I have similar structured documents in my collection. How do I query the documents that match action value to "getEmployeeData". I tried dot notation with $elemMatchbut couldn't get the results.

Refer Mongo Documentation for the same: docs.mongodb.com/manual/tutorial/query-embedded-documents & docs.mongodb.com/manual/tutorial/query-array-of-documents — Shivang Agarwal
– Shivang Agarwal, Commented May 16, 2019 at 11:28

mickl · Accepted Answer · 2019-05-16 11:10:15Z

2

Dot notation works fine here, it will return the document if serviceTask contains at least one action set to getEmployeeData

db.collection.find({
    "model.serviceTask.obj.params.action": "getEmployeeData"
})

answered May 16, 2019 at 11:10

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

Mongo db - Querying documents using nested field (nested array and objects)

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related