Discover empty fields fails in 4.0.2


#1

Hi,

during analysis i found some fields in my index were empty. For quality improvement in the source system (needs manual updates) i tried to discover all rows where specific fields are empty. But non of the searches return a result.
Checked already that there is definitely one row present matching the criteria.

I tried things like

_missing_: fieldname 

or
fieldname: NULL
or
fieldname:""

Nothing works. I am using latest kibana version 4.0.2 as well as elasticsearch 1.5.2

Do i miss something?? Any suggestions??

TMOE


(Rashid Khan) #2

Syntax is:

_missing_:someField


(Rashid Khan) #3

Also see here: https://www.elastic.co/guide/en/elasticsearch/reference/1.x/query-dsl-query-string-query.html#query-string-syntax


#4

Hi,

yes, tried _missing_:fieldname, but also does not return any result, although there are rows present where the named field has no content.

Any other idea??

TMOE


(Berkeleybross) #5

Sorry to necro this answer, but its one of the top results in google...

In kibana 5.2.2 the syntax seems to be !_exists_:"fieldname"


(system) #6