# Java code for Elasticsearch DSL

**URL:** <https://discuss.elastic.co/t/java-code-for-elasticsearch-dsl/167616>\
**Category:** Elasticsearch\
**Created:** [February 8, 2019, 11:28am UTC](https://discuss.elastic.co/t/java-code-for-elasticsearch-dsl/167616 "2019-02-08T11:28:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![examin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/examin/32/70688_2.png) [@examin](https://discuss.elastic.co/u/examin)\
**Post date:** [February 8, 2019, 11:28am UTC](https://discuss.elastic.co/t/java-code-for-elasticsearch-dsl/167616/1 "2019-02-08T11:28:50Z")

</div>

I have a elastic DSL query , Could you please guide me a bit how can i query elastic same from java code. I have read elasticsearch java api docs , and able to create client and get response for simple queries , but here i need to use stored script and 3 aggregations . Please guide me .

```
   GET /_search/
        {
          "size" : 0,
          "query" : {
            "match_all" : {
            }
          },
          "aggregations" : {
            "STAT_YEAR" : {
              "terms" : {
                "field" : "STAT_YEAR.keyword"
                },
              "aggregations" : {
                "AGE_BAND" : {
                  "terms" : {
                    "script" : {
                      "stored":"credit_limit"
                    }
                  },
                  "aggregations" : {
                    "COUNT_APPL_NO" : {
                      "value_count" : {
                        "field" : "APPL_NO.keyword"
                      }
                    }
                  }
                }
              }
            }
          }
        }
```

---

<div class="post-metadata">

**Author:** ![mayya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayya/32/83147_2.png) [@mayya](https://discuss.elastic.co/u/mayya)\
**Post date:** [February 15, 2019, 9:27pm UTC](https://discuss.elastic.co/t/java-code-for-elasticsearch-dsl/167616/2 "2019-02-15T21:27:59Z")

</div>

This [page](https://www.elastic.co/guide/en/elasticsearch/client/java-api/6.6/java-search-aggs.html) describes how to use aggregations with Java High Level Rest Client.

---

<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:** [March 15, 2019, 9:28pm UTC](https://discuss.elastic.co/t/java-code-for-elasticsearch-dsl/167616/3 "2019-03-15T21:28:11Z")

</div>

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