Min and Max condition in Kibana


(Gayathri TR) #1

Hi Team,

Could you please let me know the query for printing the logs which have min field value in discov
er.


(Jon Budzenski) #2

In the search bar:

range:
my_field:[100 TO 2000]

min:
my_field:[100 to *]

max:
my_field:[* to 100]

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#_ranges for more info.


(Gayathri TR) #3

Hi Jon,

I want to select the log which has min value of certain field.


(Jon Budzenski) #4

Ah, okay. On the sidebar, find your field and when you hover over it a button will show, click add:


Then there's a sort icon on the column:


(system) #5