Match an empty field in kibana

Hi I am trying to query kibana for empty value i.e. in the scenario where the field is present but the value sent is empty.
I used the operator "is" and matched it with different values such as ''/'*' but that returns 0 results.

1 Like

For a field called "title":

In lucene: -_exists_:title

In KQL not title:*

5 Likes

Hi Matt, thank you for your answer. I am trying to create dashboard in kibana and I want list of events where field was sent with an empty value.
So the options that I have is something as below
Filter by "field name" + Operator = 'is','is not','is one of','is not one of','exist','does not exist' + Value =
The issue that I have is I don't have value to / or not to match.
I am not using "Query DSL".

Ah I see, you're trying to create a filter not a query. What do you mean exactly when you say the field was sent with an empty value? Does the field not exist at all in the source doc? Does it have an empty string? A null value? does not exist should work if the field does not exist in the doc at all.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.