How to do multiple filter query in Elasticsearch using Java?

Question

I have build a web app on top of elasticsearch. I would like to do a multiple filter using Java.

Elasticsearch Query:

{
  "query": {
    "bool": {
      "must": [
        {"match": {
          "T": "TEXT"},
          "match": {
            "new_content": "TEXT"
          }
        },

      ],
      "filter": {
        "term": {
          "collection1": "xyz"
        },
        "term": {
          "collection2": "abc"
        }

I want to filter the query such that it should filter on the same field collection with two different values(for eg,"xyz" and "abc")

Right now, I have coded a Java program for the single filter.

BoolQueryBuilder boolQuery = QueryBuilders.boolQuery()
                .must(QueryBuilders.simpleQueryStringQuery(query).field("newContent").field("T"))
                .filter(QueryBuilders.termQuery(Collection1, "abc"));

How should I filter a query on a same field for multiple values?

Edit:

Actually in my web app, I have extracted the value of the collection as:

String[] Collection=request.getParameterValues("site");

Collection is the field in my elasticsearch documents. Suppose Collection[0] is germany_collection(value:true), Collection[1] is usa_collection(value:true). I want to write a query which filters my documents such that I will get results when germany_collection:true and usa_collection:true.

This is my original program:

public StringBuffer getJson(String query, String start, String [] Collection{
Client client = TransportClient.builder().build()
                .addTransportAddress(new InetSocketTransportAddress(InetAddress.getByName("127.0.0.1"), 9300));

        BoolQueryBuilder boolQuery = QueryBuilders.boolQuery()
                .must(QueryBuilders.simpleQueryStringQuery(query).field("newContent").field("T"))
                .filter(QueryBuilders.termQuery(Collection[0], "true").filter(QueryBuilders.termQuery(Collection[1], "true");

But when I did applied this filter, I am getting this error The method filter(TermsQueryBuilder) is undefined for the type TermsQueryBuilder. It says add cast to method reciever.

Val · Accepted Answer · 2016-06-28 02:55:39Z

11

You can use the terms query instead of multiple term queries:

BoolQueryBuilder boolQuery = QueryBuilders.boolQuery()
                .must(QueryBuilders.simpleQueryStringQuery(query).field("newContent").field("T"))
                .filter(QueryBuilders.termsQuery(Collection, "abc", "xyz"));
                                          ^                    ^      ^
                                          |                    |      |
                                    use termsQuery      with multiple values

UPDATE

I'm surprised your code compiles at all because you're missing some closing parenthesis, just rewrite your query like this and it should work:

    BoolQueryBuilder boolQuery = QueryBuilders.boolQuery()
            .must(QueryBuilders.simpleQueryStringQuery(query).field("newContent").field("T"))
            .filter(QueryBuilders.termQuery(Collection[0], "true"))
            .filter(QueryBuilders.termQuery(Collection[1], "true"));

edited Jun 28, 2016 at 2:55

answered Jun 27, 2016 at 21:07

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Rose Over a year ago

Sorry. I messed up in asking a proper question. Can you please check my edit part?

Rose Over a year ago

It worked. Thanks. There was an error because of the missing closing parenthesis. Thanks again

Shetty Suresh Babu. · Accepted Answer · 2020-03-11 14:07:27Z

0

Term query will take only one value for the filed, Terms query will take multiple values for the filed

SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
BoolQueryBuilder QueryBuilders = QueryBuilders.boolQuery();

sourceBuilder.query(QueryBuilders.filter(QueryBuilders.termsQuery("age", "44", "45", "30")));

strong text searchRequest.source(sourceBuilder);

answered Mar 11, 2020 at 14:07

Shetty Suresh Babu.

7041 gold badge6 silver badges9 bronze badges

2 Comments

Stephane Over a year ago

How to go if one cannot hard code the values ? Say if having a collection with the values.

Stephane Over a year ago

Probably like QueryBuilders.termsQuery("name", Arrays.asList(values))

Collectives™ on Stack Overflow

How to do multiple filter query in Elasticsearch using Java?

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related