Searching nested array elements in mongodb

Question

i have collection called 'test' in that there is a document like:

{
"_id" : 1
"letters" : [ 
        [ "A", "B" ], 
        [ "C", "D" ], 
        [ "A", "E", "B", "F" ]
    ]
}

if i search like this:

db.getCollection('test').find({"_id" : 1}, {"letters": ["A", "B"] })

then it will fetch the record.

{
"_id" : 1
"letters" : [ 
        [ "A", "B" ], 
        [ "C", "D" ], 
        [ "A", "E", "B", "F" ]
    ]
}

if i search like this:

db.getCollection('test').find({"_id" : 1}, {"letters": ["B", "A"] })

it doesn't fetch the record

my requirment is if im give like this also (["B", "A"]), it have to fetch the document. Because the same letters are already present in the array.

i will try with $all operator but it doesn't work

db.getCollection('test').find({"_id" : 1}, {"letters": {$all: ["B", "A"]} })

now also it will not fetch the record

could anyone can please give the solution.

OP: You have two distinct things going on here: update and query. Perhaps you can separate them and describe your desired output? — Buzz Moschetti
– Buzz Moschetti, Commented Nov 23, 2017 at 4:13

Mehraj Malik · Accepted Answer · 2017-11-23 06:27:43Z

0

You can do something like this :

 db.test.find(
       {
        "$and":[
         {"_id" : ObjectId("5a16674b4828c9f51d3b3a18")},
         {"$or":[{"letters": ["A", "B"] },{"letters": ["B", "A"] }]}
               ]
       }
      )

Now it will search the document who has ["A","B"] OR ["B","A"].

edited Nov 23, 2017 at 6:27

answered Nov 23, 2017 at 6:22

Mehraj Malik

16k18 gold badges61 silver badges88 bronze badges

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

1 Comment

Ayush Gupta Over a year ago

While this will work, if the letters to match increase in count, this solution will become too complex.

Mehul Prajapati · Accepted Answer · 2017-11-23 06:44:14Z

0

    db.getCollection('test').find(
        {
            "_id" : 1,
            'letters':{
                $elemMatch:{
                    $elemMatch:{
                        $in:['B','A']
                    }
                }
            }
        }
    )

This query will find all the documents which has array elements you specify in last $in close, example, It will find same document if you specify only $in:['C'] or $in:['B','A']

answered Nov 23, 2017 at 6:44

Mehul Prajapati

1,2612 gold badges12 silver badges30 bronze badges

Collectives™ on Stack Overflow

Searching nested array elements in mongodb

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related