How to AND multiple setQuery in elasticsearch using java?

user_9814965 0
Viewed 384

I am trying to create query for search filter using elasticsearch. I created query that shows results based on search term, price range and brand list. Results shown for searchterm and price range is right but when brand list is provided all results related to selected brand is shown.

I want results for searchterm AND price AND brands

This is my query

BoolQueryBuilder query = QueryBuilders.boolQuery();
for (String key : brands) {
    query.must(QueryBuilders.matchQuery("brand", key));
}

SearchResponse searchresponse = client
        .prepareSearch("product")
        .setTypes("product")
        .setQuery(
                QueryBuilders.matchPhraseQuery("name", pSearchTerm))
        .setPostFilter(
                QueryBuilders.rangeQuery("unit_price").from(min)
                        .to(max))
        .setQuery(query).setExplain(true)
        .execute().actionGet();

what am i doing wrong here?

elasticsearch spring-boot java
1 Answers

You have two setQuery() calls so the second one is overriding the first one. You need to combine all your constraints into one query like this:

// brand list
BoolQueryBuilder query = QueryBuilders.boolQuery();
for (String key : brands) {
    query.must(QueryBuilders.matchQuery("brand", key));
}

// search term
query.must(QueryBuilders.matchPhraseQuery("name", pSearchTerm));

// price range
query.filter(QueryBuilders.rangeQuery("unit_price").from(min).to(max));

SearchResponse searchresponse = client
    .prepareSearch("product")
    .setTypes("product")
    .setQuery(query)
    .setExplain(true)
    .execute().actionGet();
user_46045790
Related