mongo db nested object and array filter

Question

{  
 "_id": {    
    "$oid": "1234567"  
 },  
 "para": {       
   "lisobj": {      
       "abcd": 
        [  "1234"      ]    
   },
 }
}

I have the above mongo doc, I am trying to write a filter to see if there are any doc which have the following key:

"para.lisobj.abcd" exists.

But I am not sure what would be the proper mongo filter to find the doc which has the field.

I tried the below filter but it doesn't work:

{"para.lisobj.abcd" : { "exists": true} }

YuTing · Accepted Answer · 2022-04-21 08:49:29Z

1

You miss $ at exists

db.collection.find({
  "para.lisobj.abcd": {
    $exists: true
  }
})

answered Apr 21, 2022 at 8:49

YuTing

6,6692 gold badges8 silver badges19 bronze badges

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

1 Answer 1