querying nested JSON in mongodb using find

Question

My JSON is:

db.col.insert([

    {
        "1":[
            {
                "a":"1",
                "b":"2",
                "v":"12"
            }
        ]
    },
    {
        "2":[
            {
                "a":"12",
                "v":"451"
            }
        ]
    }])

when I query using

db.col.find("1")

It is returning both the rows instead of the condition. how can i select just one row here?

Parvin Gasimzade · Accepted Answer · 2014-01-27 13:39:29Z

1

You can filter the data by checking if the given field exists using $exists keyword as follows :

db.col.find({1 : {$exists:true}})

answered Jan 27, 2014 at 13:39

Parvin Gasimzade

26.1k8 gold badges58 silver badges83 bronze badges

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

Collectives™ on Stack Overflow

querying nested JSON in mongodb using find

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