Find in double nested array

Question

I have a document like this:

{ 
   "_id":ObjectId("5b306824a1eab22e77858c88"),
   "data":{ 
      "Key":[ 
         [ 
            "1529587723",
            "KeyIn"
         ],
         [ 
            "1529587723",
            "Num"
         ],
         [ 
            "1529667745",
            "KeyIn"
         ]
      ]
   },
   "devicecode":"MP1D1XAH@LENOVO"
}

my question is how to find all records with "KeyIn"? I tried

db.dataup.find({ "data.key": "KeyIn" })

but it doesn't work.

Ashh · Accepted Answer · 2019-09-17 06:36:51Z

4

You need to use double nested $elemMatch to find in double nested arrays

db.collection.find({
  "data.Key": {
    "$elemMatch": {
      "$elemMatch": { "$in": ["KeyIn"] }
    }
  }
})

MongoPlayground

edited Sep 17, 2019 at 6:36

answered Sep 17, 2019 at 6:19

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

1 Comment

Himanshu Sharma Over a year ago

A perfect piece of query!!

Collectives™ on Stack Overflow

Find in double nested array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related