# Elastic Search - QueryBuilder JAVA

**URL:** <https://discuss.elastic.co/t/elastic-search-querybuilder-java/312148>\
**Category:** Elasticsearch\
**Tags:** language-clients\
**Created:** [August 16, 2022, 7:55am UTC](https://discuss.elastic.co/t/elastic-search-querybuilder-java/312148 "2022-08-16T07:55:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Parva\_Gurav](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parva_gurav/32/109685_2.png) [@Parva\_Gurav](https://discuss.elastic.co/u/Parva_Gurav)\
**Post date:** [August 16, 2022, 7:55am UTC](https://discuss.elastic.co/t/elastic-search-querybuilder-java/312148/1 "2022-08-16T07:55:22Z")

</div>

I'm currently working on elasticsearch where I've created a query :

```auto
"query": {

    "bool": {
      "must": [
        {"match": {
          "companyId": 35
        }},
        {
          "multi_match": {
            "query": "movie",
            "fields": ["name", "description"]
          }
        }
      ]
    }
  }
}

```

For which I have build QueryBuilder in JAVA :

```auto
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

                
        QueryBuilder mulMatch = QueryBuilders.multiMatchQuery(name,"name", "description").type("phrase").boost(5);
        QueryBuilder cId = QueryBuilders.matchQuery("companyId", companyId).boost(5);
        QueryBuilder must = QueryBuilders.boolQuery().must(cId).must(mulMatch).boost(5);
        
        searchSourceBuilder.query(must);
        searchRequest.source(searchSourceBuilder);
        System.out.println("SS Query : " + searchSourceBuilder);

```

which gives me query created as :

```auto
{"query":{"bool":{"must":[{"match":{"companyId":{"query":35,"operator":"OR","prefix_length":0,"max_expansions":50,"fuzzy_transpositions":true,"lenient":false,"zero_terms_query":"NONE","auto_generate_synonyms_phrase_query":true,"boost":5.0}}},{"multi_match":{"query":"movie","fields":["description^1.0","name^1.0"],"type":"phrase","operator":"OR","slop":0,"prefix_length":0,"max_expansions":50,"zero_terms_query":"NONE","auto_generate_synonyms_phrase_query":true,"fuzzy_transpositions":true,"boost":5.0}}],"adjust_pure_negative":true,"boost":5.0}}}

```

However, I require output such as :

```auto
{

          "Id": 1,
          "name": "Controle",
          "description": "Welcome movie",
          "visibility": "2",
          "isarticleEnabled": false,
          "companyId": 35,
          "categoryId": 0        
}

```

So to get such a a response, what should I exactly do? What do I need to write in queryBuilder to get the required output?

Note: I've searched for all the relative solutions, i.e. Search Request, Search Response, but I was unable to get any of the proper solutions.

---

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [August 16, 2022, 12:27pm UTC](https://discuss.elastic.co/t/elastic-search-querybuilder-java/312148/2 "2022-08-16T12:27:24Z")

</div>

Hi @Parva_Gurav

> [@Parva\_Gurav](#):
>
> which gives me query created as :

The query not works?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 13, 2022, 12:27pm UTC](https://discuss.elastic.co/t/elastic-search-querybuilder-java/312148/3 "2022-09-13T12:27:25Z")

</div>

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