How to find numbers starting with 80?

[Gosforth]

Hi,

Kibana Discover option. I'd like to display all docs that has filed value (number) starting with 20.
Possible to do this?
In SQL it would be ...WHERE field1 LIKE '20%'
How to do this in Kibana?
Regards

[Vikash_Kumar1 (Vikash Kumar)]

You can make use of the "regexp" option. It will apply the regexp to the terms.

GET <index_name>/_search
{
"query": {
"regexp":{
"field_name": "20"
}
}
}

[Gosforth]

Good, thank you very much. But how to do this in Kibana menu? Query syntax is too complex for ordinary user - they use GUI.

[Askia_Mohamed_Kadri (Askia Mohamed Kadri Mounkaïla)]

I'm not sure but I donc think that LIKE operation is possible on number. You can use range instead. LIKE is only for text fields

[Gosforth]

Thanks but looks like range will give me nothing; I'd like to find with article number starting with 80 not greater or smaller than 80. Hard to believe such basic operator does not exists in Elastic

[Christian_Dahlqvist]

You can use a regex query, but that requires the field to be mapped as keyword, not a number.

[Gosforth]

Thanks. Maybe you can add this to the wishlist? Looks like basic function....

[Christian_Dahlqvist]

If it is not a field you will be doing mathematical operations on, e.g. a phone number or a numeric article id, you should send it as a string and map it as keyword.