I have some job data I’m storing in elasticsearch, lets say: { name : (optional) status : [running/waiting] @timestamp : … } I can plot a count of all running jobs with the query “status:running”, I can plot a count of all running jobs which have a name using “status:running and name:*”. How…

Think you can combine MustNot and Exists : GET /_search { "query": { "bool": { "must_not": { "exists": { "field": "name" } } } } }

Hi @daniellee , How could I do that in Grafana? I mean, how can we apply mustnot and exists in grafana? In my case I’m trying not to show null values in the Graph panel, so I’d like to use exists.

Good question. Hard to remember the details 5 months later but maybe with these lucene extensions: https://github.com/elastic/kibana/issues/1247#issuecomment-43756601 See the querystring syntax section here .

_exists_ did the trick, thanks :slight_smile:

Hi, We want similar filter in Grafana . We have below reference field in Grafana with value. references [null_reference] Can you explain how exists works in Lucene syntax? Thanks & Regards, Jalpesh

Hi i tried implementing it for one field Request.CustomerId: null but data is not coming. i have tried changing the panel type also. Can you please help? Although data is coming in full logs but creating panel on above query showing no data.

How to query for null values?

Grafana Elasticsearch

jcarnero October 9, 2017, 10:59pm 5

_exists_ did the trick, thanks

Topic		Replies	Views
How to implement an Elasticsearch null query in Grafana Elasticsearch	1	2119	November 1, 2018
Querying for Null values from elasticsearch data source Elasticsearch	3	7408	May 11, 2020
The problem with All option in ES filter when some of the values for the field do not exist Elasticsearch	17	15141	April 7, 2020
Query variable for Elasticsearch - count null values Elasticsearch	1	757	January 8, 2021
Grafana Table or Graph plugin with Elasticsearch not able to filter Elasticsearch elasticsearch	0	676	February 1, 2021

How to query for null values?

Related topics