MongoDB - Query for "is not null" not working

Question

I'm working with a MongoDB table and I have problems getting the documents with values different from null in some fields. I assume that I'm using the $ne operator wrong, but, given this document:

{
  "createdAt" : "2022-04-07T13:18:18Z",
  "expired" : false,
  "responses": [
    {
      "id": "header",
      "options": [
        {
          "id": "1",
          "text": ""
        }
      ],
      "textForSearch": null
    },
    {
      "id": "content",
      "options": [
        {
          "id": "content test 01",
          "text": "content test 01"
        },
        {
          "id": "content test 02",
          "text": "content test 02"
        }
      ],
      "title": "test title",
      "questionType": "selection",
      "textForSearch": null
    },
    {
      "id": "footer",
      "options": [
        {
          "id": "negative",
          "text": "Negative"
        },
        {
          "id": "positive",
          "text": "Positive"
        }
      ],
      "title": "test title",
      "questionType": "selection",
      "textForSearch": null
    },
    {
      "id": "test_id",
      "options": null,
      "title": "",
      "questionType": "text",
      "textForSearch": "comentario de test"
    }
  ]
}

The following query:

db.getCollection('table').find({"responses.textForSearch": {$ne: null} })

result in:

Fetched 0 record(s) in 1ms.

What am I missing?

Yong Shun · Accepted Answer · 2022-04-10 01:40:09Z

2

Use $elemMatch operator.

You may refer to Single Query Condition to see the sample that using dot notation and $elemMatch produce the different results when using with $not or $ne operators.

db.collection.find({
  "responses": {
    "$elemMatch": {
      "textForSearch": {
        $ne: null
      }
    }
  }
})

Sample Mongo Playground

edited Apr 10, 2022 at 1:40

answered Apr 10, 2022 at 1:34

Yong Shun

54.6k6 gold badges38 silver badges66 bronze badges

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

1 Comment

bcurti Over a year ago

Im testing this and seems to work fine. I didnt know about $elemMatch, Im pretty new at mongodb. Thank you very much for your time and contribution.

Collectives™ on Stack Overflow

MongoDB - Query for "is not null" not working

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