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

(Jon Budzenski) #2

In the search bar:

my_field:[100 TO 2000]

my_field:[100 to *]

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