Question

0

393

Views

Mongodb query to check if a particular field is not null ( aggregation)

I have queries like

{
"title": "sjncx",
"desciption": "cknxk jckd",
"price": "29.99",
"stock": "3",
...
}

I need to filter data if the title is not empty.( title exists and not null). And also is empty like ~ title: "" ~ ( so title exists but empty)

I tried for is not empty:

{'title': {'$ne': 'null'}}

I tried for is empty:

{'title': {'$type': 10}}

That doesn't work. What would be the reason?

over 4 years ago · Santiago Trujillo

2 answers

Answer question

0

Use $and which is very expressive

db.collection.find({
  "$and": [
    {
      "title": {
        "$ne": null
      }
    },
    {
      "title": {
        "$ne": ""
      }
    }
  ]
})

You will just set your condition there. The doc

See: https://mongoplayground.net/p/V13mnmf6xGE

over 4 years ago · Santiago Trujillo Report

Answer question

Find remote jobs

Accepted Answer · 2022-05-13T14:55:24.206Z

You can use $in to cover both cases empty and null :

{
  "title": {
    "$nin": [null, ""]
  }
}

Try it here

0

393

Mongodb query to check if a particular field is not null ( aggregation)

2 answers

0

0

Find remote jobs

Andres GPT