MongoDB - Find Data from a array inside a object

Question

I have my db in following form

{
"_id" : ObjectId("56fc92adcf908c9f296e5885"),
"_class" : "com.abc.ppm.dto.AccessAttemptDTO",
"url" : "/myProject/edit",
"ipAddress" : "127.0.0.1",
"param" : {
    "iecode" : [ 
        "P1234"
    ],
    "id" : [ 
        "5696578c6d34f835dc632fdd "
    ]
},
"accessTime" : "30-3-2016 10:59:57",
"email" : "[email protected]",
"entity" : "admin",
"entityCode" : ""
},

{
"_id" : ObjectId("56fc92adcf908c9f296e5887"),
"_class" : "com.abc.ppm.dto.AccessAttemptDTO",
"url" : "/myProject/edit",
"ipAddress" : "127.0.0.1",
"param" : {
    "iecode" : [ 
        "P1122"
    ],
    "id" : [ 
        "5696578c6d34f835dc632fdd "
    ]
},
"accessTime" : "30-3-2016 10:59:57",
"email" : "[email protected]",
"entity" : "admin",
"entityCode" : ""

}

Now I want to find all the enries where iecode is 'P1234'. How do I do that? (Note: iecodes value is stored in string array format.)

Sede · Accepted Answer · 2016-05-07 14:00:16Z

2

You can write query like:

db.collectionName.find({"param.iecode": "P1234"})

edited May 7, 2016 at 14:00

Sede

61.5k20 gold badges158 silver badges162 bronze badges

answered May 7, 2016 at 11:21

Pranab Sharma

73510 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Find Data from a array inside a 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