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, Nov 23 '17 at 04:13
check this [how to change order of array with mongodb](https://stackoverflow.com/questions/35810951/how-to-change-order-of-array-with-mongodb) — godsenal, Nov 23 '17 at 04:25

Mehraj Malik · Answer 1 · 2017-11-23T06:27:43.150

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 '17 at 06:27

answered Nov 23 '17 at 06:22

Mehraj Malik

14,872
15
58
85

While this will work, if the letters to match increase in count, this solution will become too complex. – Ayush Gupta Nov 29 '17 at 03:33

score 0 · Answer 2 · answered Nov 23 '17 at 06:44

    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']

Searching nested array elements in mongodb

2 Answers2