elasticsearchelasticsearch-2.0elasticsearch-dsl

Elasticsearch, Exists filter for nested objects not working


My mapping is:

"properties": {
  "user": {
    "type": "nested",
    "properties": {
      "id": {
        "type": "integer"
      },
      "is_active": {
        "type": "boolean",
        "null_value": false
      },
      "username": {
        "type": "string"
      }
    }
  },

I want to get all documents that do not have a user field.

I tried:

GET /index/type/_search
{
  "query": {
    "bool": {
      "must_not": [
        {
          "exists": {
            "field": "user"
          }
        }
      ]
    }
  }
}

Which returns all documents. Based on ElasticSearch 2.x exists filter for nested field doesn't work, I also tried:

GET /index/type/_search
{
  "query": {
    "nested": {
      "path": "user",
      "query": {
        "bool": {
          "must_not": [
            {
              "exists": {
                "field": "user"
              }
            }
          ]
        }
      }
    }
  }
}

Which returns 0 documents.

What is the correct query to get all documents missing the user field?


Solution

  • I found the correct syntax, it should have been:

    GET /index/type/_search
    {
      "query": {
        "bool": {
          "must_not": [
            {
              "nested": {
                "path": "user",
                "query": {
                  "exists": {
                    "field": "user"
                  }
                }
              }
            }
          ]
        }
      }
    }