Elasticsearch java api or filter

Question

I need to apply an "OR" filter, which would be equivalent to category in ('a' or 'b' or 'c' or 'd' or 'e') an equivalent ES query is provided below

"query_string": {
                      "query": "category: (\"a\", \"b\", \"c\", \"d\", \"e\")"
                   }

I have this below mentioned JAVA ES API code and I am struck in adding OR filter in Java. Can somebody help please?

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder()
     searchSourceBuilder.query(QueryBuilders.boolQuery()
                .must(QueryBuilders.filteredQuery(QueryBuilders.matchAllQuery(),
                        FilterBuilders.termFilter("category","a")))
                .must(QueryBuilders.rangeQuery("@timestamp").from(fromHr).to(toHr)))
                .fields(fieldList);

Michael Stockerl · Accepted Answer · 2016-04-01 19:37:07Z

1

Based on your example, I assume you are using ES 1.x and assume the RangeQuery should be a query. If I understand your question correctly you want do something like this:

QueryBuilders.filteredQuery(
 QueryBuilders.rangeQuery("@timestamp").from(fromHr).to(toHr),
 FilterBuilders.boolFilter()
  .should(FilterBuilders.termFilter("category","a"))
  .should(FilterBuilders.termFilter("category","b")) 
  .should(FilterBuilders.termFilter("category","c")) 
  .should(FilterBuilders.termFilter("category","d"))   
  .should(FilterBuilders.termFilter("category","e"))
)

However, you can also use the terms filter:

QueryBuilders.filteredQuery(
  QueryBuilders.rangeQuery("@timestamp").from(fromHr).to(toHr),
  FilterBuilders.termsFilter("category", "a", "b", "c", "d", "e", "f" ))

answered Apr 1, 2016 at 19:37

Michael Stockerl

7495 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adithya Kumar Over a year ago

Thank you so much Micheal !

Collectives™ on Stack Overflow

Elasticsearch java api or filter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related