Value does not exist or value is null for specific field in Elasticsearch (query_string)

Question

I'm attempting to search for null or non-existant values for specific fields with query_string. My existing query is as follows:

{
    "query": {
        "query_string" : {
            "query" : "stringProperty.keyword:01 AND booleanProperty:false",
            "analyze_wildcard" : false,
            "allow_leading_wildcard": false
        } 
    }
}

Not sure if it's possible, I could not find anything useful in documentation.

Val · Accepted Answer · 2022-09-06 12:00:44Z

1

In order to search for a document having a field with a null or non-existent value with query_string you can do it like this:

 "query" : "NOT(_exists_:stringProperty.keyword)"

answered Sep 6, 2022 at 12:00

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Value does not exist or value is null for specific field in Elasticsearch (query_string)

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