# Create a Java Query from a DSL terms query

**URL:** <https://discuss.elastic.co/t/create-a-java-query-from-a-dsl-terms-query/349584>\
**Category:** Elasticsearch\
**Created:** [December 18, 2023, 5:27pm UTC](https://discuss.elastic.co/t/create-a-java-query-from-a-dsl-terms-query/349584 "2023-12-18T17:27:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edgar\_Osorio](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/edgar_osorio/32/126951_2.png) [@Edgar\_Osorio](https://discuss.elastic.co/u/Edgar_Osorio)\
**Post date:** [December 18, 2023, 5:27pm UTC](https://discuss.elastic.co/t/create-a-java-query-from-a-dsl-terms-query/349584/1 "2023-12-18T17:27:45Z")

</div>

Given the following Query

```auto
{
    "query":{
    "bool" : {
        "must" : [ {                   
        "terms" : {
            "_id" : ["8606874","21387518","16704862","23947520","23897437","1050114","24967566","5035697","12354041","17037068","20316927","23405734","12594216","2252927","17434782","23872254","24177201","4557946","1015260","3164537","6369537","10790781","4224488","23117230","1050119","12525387","23692179","5585321","16644872","3727442","20378284","21506949","1015271","2490589","1047006","1015228","10782526","12280902","23465365","789184"]
     }
   }, {
        "terms" : {
            "cuisine.key" : ["10345"]
     }
   } ]
 }
}}

```

What would be the correct Java API implementation. Any pointer in the right direction would be really helpful.

Thanks!

---

<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:** [December 19, 2023, 7:31pm UTC](https://discuss.elastic.co/t/create-a-java-query-from-a-dsl-terms-query/349584/2 "2023-12-19T19:31:59Z")

</div>

Hi @Edgar_Osorio

Look this example:

```
List<FieldValue> ids = new ArrayList<FieldValue>();
ids.add(FieldValue.of("1"));
ids.add(FieldValue.of("2"));

List<FieldValue> cousines = new ArrayList<FieldValue>();
cousines.add(FieldValue.of("1"));

Query termCuisine = TermsQuery.of(ts -> ts
    .field("_id)
    .terms(TermsQueryField.of(t -> t.value(ids))))._toQuery();

Query termIds = TermsQuery.of(ts -> ts
    .field("cuisine.key"")
    .terms(TermsQueryField.of(t -> t.value(cousines))))._toQuery();

var boolQuery = new BoolQuery.Builder().must(termIds, termCuisine).build();

```

---

<div class="post-metadata">

**Author:** ![Edgar\_Osorio](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/edgar_osorio/32/126951_2.png) [@Edgar\_Osorio](https://discuss.elastic.co/u/Edgar_Osorio)\
**Post date:** [December 20, 2023, 9:52pm UTC](https://discuss.elastic.co/t/create-a-java-query-from-a-dsl-terms-query/349584/3 "2023-12-20T21:52:46Z")

</div>

It did work like a charm

Thank you so much for your help!

---

<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:** [January 17, 2024, 9:52pm UTC](https://discuss.elastic.co/t/create-a-java-query-from-a-dsl-terms-query/349584/4 "2024-01-17T21:52:50Z")

</div>

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