Filtering for multiple values of a single field

I have a status field, which can have one of the following values,

image(4)

I can filter for data which have status completed. I can also see data which has ongoing.

But I want to display only the data which have status completed and ongoing at the same time.

But I don't know how to add filters for 2 values on a single field.

How can I achieve what I want ?

What about just using an OR in the filter?

booking_status:(completed OR ongoing)

See: https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#query-string-syntax

4 Likes

Yeah Cool.

But how can I use it in kibana ?

Like here I have filtered for status:completed, can I put 2 filters like this ?

I know I can edit this query, but I need a simpler way to show it to my marketing team(which have no idea about editing this query), and I need a simple way to convince them.

You can type the filter in the bar with the "Filter ..." text.

It looks like you are using Kibana 5.x, but stay tuned for huge improvements to the query bar coming in 6.0: https://www.elastic.co/guide/en/kibana/6.0/kuery-query.html The new "Kuery" functionality should make it easier for the Marketing team. :wink:

2 Likes

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