Min and Max condition in Kibana

Hi Team,

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

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.

Hi Jon,

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

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: