Best way to deal with empty fields?

erikg · August 12, 2024, 10:25pm

Hello,

I have a field that seems to come in as "--" so I removed it.
The due to removing it, the field now its "(empty)".

The issue I want to filter out these fields but both appear:

I even did "exists" and they both still appear:

what is the best approach to ensure that the filters work?

Alex_Salgado-Elastic · August 13, 2024, 3:35am

Hi @erikg , what happens whe you try :
NOT field_test.keyword: "--" and NOT field_test : *

erikg · August 13, 2024, 7:11pm

Hey @Alex_Salgado-Elastic
No results appear using your query:

Alex_Salgado-Elastic · August 14, 2024, 6:58pm

Hello @erikg , just to clarify.
What was the expected outcome? Can you provide an example?

erikg · August 14, 2024, 10:07pm

Hello @Alex_Salgado-Elastic ,

The expected outcome is to possible filter out empty and "--" fields.

In my example: I have actual values for "nextcloud.user" field (if you look at the very bottom row of the pictures). I just seem to have empty or null fields that are not filtering out.

I believe this might be a bug.