MongoDB find an object by specifying nested value

Question

[
{
    customer: {
        field 1: {},
        field 2: {},
        answers: {
            "BUSI_EXP": { "answered": true, "updated": "date" },
            "NEW_HOME": { "answered": true, "updated": "date" },
            "VEHICLE": { "answered": true, "updated": "date" }
        }
    }
},
{
    customer: {
        field 1: {},
        field 2: {},
        answers: {
            "BUSI_EXP": { "answered": false, "updated": "date" },
            "NEW_HOME": { "answered": false, "updated": "date" },
            "VEHICLE": { "answered": true, "updated": "date" }
        }
    }
}
]

Here's my customer collection. As you can see, it has an answers field that has an answered flag for each key. How do i get all customers who answered any of the answers as true ?

Sachin · Accepted Answer · 2016-10-13 12:47:20Z

2

try:

    db.collectionname.find({ $or:[{"customer.answers.BUSI_EXP.answered": true},
{"customer.answers.NEW_HOME.answered": true},
{"customer.answers.VEHICLE.answered": true}});

edited Oct 13, 2016 at 12:47

answered Oct 13, 2016 at 12:41

Sachin

2,93219 silver badges26 bronze badges

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

3 Comments

Syed Is Saqlain Over a year ago

Thanks for the answer. I just edited the question. I hadn't asked what i really wanted to.

Syed Is Saqlain Over a year ago

Is there not a way to iterate over the keys ? This is a small part of the actual collection there are about 80 keys to the answers field

Sachin Over a year ago

No, you have to specify keys with $or.

Collectives™ on Stack Overflow

MongoDB find an object by specifying nested value

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related