How to find numbers starting with 80?

Elastic Stack Kibana
1

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

2

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"
}
}
}

3

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

4

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

5

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 :frowning:

6

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

7

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

8

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.

9

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.