Mongo query to find not null string inside list of objects

Question

I want to query an array of objects with a particular key should have text in it.

this is the query I have tried

to find disclaimer.text exists and not empty. But It always prints 0

 db.slideshows.count({"config.slides": { $elemMatch: {disclaimer: {"text" :   {"$exists" : true, "$ne" : ""}  }} } })

This is my data

 {
 "id": 1002,
 "config": {
"firstSlide": "vehicle",
"slides": [
  {
    "slideKey": "sk1",
    "disclaimer": {
      "text": ""
    }
  },
  {
    "slideKey": "sk2"
   }
  ]
 }
}

{
"id": 1003,
"config": {
"firstSlide": "book",
"slides": [
  {
    "slideKey": "sk3",
    "disclaimer": {
      "text": "Hello"
    }
  },
  {
    "slideKey": "sk4"
   }
  ]
 }
}

{
"id": 1004,
"config": {
"firstSlide": "book",
"slides": [
  {
    "slideKey": "sk3",
    "disclaimer": {
      "text": "nope"
    }
  },
  {
    "slideKey": "sk4",
    "disclaimer": {
      "text": ""
    }
   }
  ]
  }
 }

I want all the rows which have not empty disclaimer.text. ex. in the above set I need to get id 1004 and 1003 as a result.

sushant mehta · Accepted Answer · 2019-09-11 11:49:41Z

1

Try

db.slideshows.count({
  "config.slides": {
    $elemMatch: {
      "disclaimer.text": {
        "$exists": true,
        "$ne": ""
      }
    }
  }
})

answered Sep 11, 2019 at 11:49

sushant mehta

1,2841 gold badge7 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Mongo query to find not null string inside list of objects

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