Find query on nested json object

Question

I have document structure like:

{
      "date": "2017-02-28T13:06:05Z",
      "id": "370adb62d5b1461ead2c4d9410710482",
      "json": {
              "flag": true,
              "key": "abc",
              "no":{ 
                    "no1":"one",
                    "no2":"two"
                   }
               }
}

I want to retrive documents where key equals "abc" and no1 equals "one"

Please help !

Please show us your effort and tell us where you are stuck. So that we can help you out to solve your issue. — Shrabanee
– Shrabanee, Commented May 24, 2017 at 12:39

felix · Accepted Answer · 2019-04-03 08:47:57Z

2

this should do the trick :

db.collection.find({"json.key": "abc", "json.no.no1": "one"})

try it online: mongoplayground.net/p/XelDmKBa6JS

edited Apr 3, 2019 at 8:47

answered May 24, 2017 at 12:39

felix

9,3158 gold badges44 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Find query on nested json object

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