mongodb query using $in for list of lists

Question

I have a document as:

{
    'name':'XYZ',
    'address':'Street 21',
    'phone': {
        'home': [123456, 456123]
    },
    'qualification': {
        'primary': [
            ['AB','75'],
            ['CD','80'],
            ['EF','50']
        ]
    }
}

Simple query would be like:

n = collection.find({'name':'XYZ'})

I can fetch documents using a list on the 'phone.home' subdocument key like this:

list1 = [123456]
n = collection.find({'phone.home':{'$in': list1}})

I am stuck on how to query the collection using the qualification key. Suppose I have either 'AB' or '75' (only one of them at a time), I am not able to make up query, e.g I only have the following list1:

list1 = ['AB']

n = collection.find({'qualification.primary':{'$in':list1}})

This definitely is not giving me the desired result. Any guidance will be appreciated!

Sede · Accepted Answer · 2015-06-08 11:28:56Z

3

Use $elemMatch two times query as :

db.collectionName.find(
    {
      "qualification.primary":{ "$elemMatch": { "$elemMatch":{ "$in": ["AB"] }}}
    },
    { "qualification.primary.$":1 }
)

edited Jun 8, 2015 at 11:28

Sede

61.5k20 gold badges158 silver badges162 bronze badges

answered Jun 8, 2015 at 11:15

Neo-coder

7,8585 gold badges36 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

mongodb query using $in for list of lists

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