Elasticsearch nested field not exist query in DSL python

Question

I have a nested data mapping in a document and I want to query if a nested field does not exist.

This elastic query is working but what will be the elastic DSL representation on this query?

GET products/_search

{
  "query": {
    "bool": {
      "must_not": [
        {
          "nested": {
            "path": "attributes",
            "query": {
              "exists": {
                "field": "attributes.value"
              }
            }
          }
        }
      ]
    }
  }
}

I have tried with this, but it's not working

ProductDocument.search().query(
    "nested",
    path="attributes",
    query=(~Q('exists', field='attributes.value'))
)

This DSL query represent as and it's wrong I think

{
  "query": {
    "nested": {
      "path": "attributes",
      "query": {
        "bool": {
          "must_not": [{
            "exists": {
              "field": "attributes.value"
            }
          }]
        }
      }
    }
  }
}

N.B: I am using elastic 6.7, elasticsearch-dsl 6.4.2

Dharman · Accepted Answer · 2025-05-08 13:21:12Z

3

Finally, I find out the query

ProductDocument.search().query(~Q(
    "nested",
    path="attributes",
    query=Q("exists", field='attributes.value'))
))

edited May 8 at 13:21

Dharman♦

33.9k27 gold badges103 silver badges157 bronze badges

answered Nov 16, 2020 at 21:10

frfahim

51510 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch nested field not exist query in DSL python

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