Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Search for list of possible values in one field

In kibana I want to define a query, which will find all entries containing a field numberwith either a value of 234, 231, 1.

Is there a way to define a query, looking something like number: (234, 231, 1)(This does not work).

Currently my only working query looks like: (number:234 OR number:231 OR number:1).

like image 408
Florian Avatar asked Dec 06 '16 15:12

Florian


2 Answers

Kibana uses Lucene query syntax.

You can't feed a conventional list to a field, but something like:

page_root:(owa OR ews OR autodiscover)

should work in lieu of the much more verbose

(page_root:owa OR page_root:ews OR page_root:autodiscover)
like image 101
Ivan Avatar answered Jan 04 '23 06:01

Ivan


For numeric values it does not work, but works if we quote the numbers i.e. number: (234, 231, 1) will not work but number: ("234", "231", "1") works

like image 43
Karsankaka Avatar answered Jan 04 '23 06:01

Karsankaka