Querying array of nested objects in MongoDB

Question

I was wondering what I'm doing wrong here. I'm trying to query an array of objects. I'm expecting to get the document below, but I'm getting nothing instead.

This is the collection:

[
    {
        _id: ObjectId("5ef1714fc77dd22599054c8d")
        "surveyName": 'Sample',
        "participants": [
            {
                "name": 'John'
                "answers": {
                    'question1': 'abc',
                    'question2': 'def'
                }
            },
            {
                "name": 'Paul'
                "answers": {
                    'question1': 'def',
                    'question2': 'abc'
                }
            }
        ]
    }
]

This is the query I'm trying to run:

db.surveys.find({
    _id: ObjectId("5ef1714fc77dd22599054c8d"),
    'participants.answers': { 
        '$elemMatch': { 
            '$or': [ 
                {'question1': 'abc'},
                {'question2': 'def'}
            ]
        }
    }
})

Result:

Fetched 0 record(s) in 22ms

Thanks!

Answer 1

How about avoiding element match and do this instead?

db.surveys.find({
    $or: [{"participants.answers.question1":"abc"}, {"participants.answers.question2":"xyz"}]
})