# Spring data Elasticsearch

**URL:** <https://discuss.elastic.co/t/spring-data-elasticsearch/361089>\
**Category:** Elasticsearch\
**Tags:** language-clients\
**Created:** [June 9, 2024, 2:26am UTC](https://discuss.elastic.co/t/spring-data-elasticsearch/361089 "2024-06-09T02:26:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mmahmood](https://avatars.discourse-cdn.com/v4/letter/m/df788c/32.png) [@mmahmood](https://discuss.elastic.co/u/mmahmood)\
**Post date:** [June 9, 2024, 2:26am UTC](https://discuss.elastic.co/t/spring-data-elasticsearch/361089/1 "2024-06-09T02:26:40Z")

</div>

Hi all

I have added aggregation to elasticsearch query by using QueryBuilder class provided in spring boot elasticsearch library but it is not working as expected. I may be missing something.

following is code snippet  
queryBuilder.withFilter( q -\> q  
.bool(b -\> b.must(m -\> m.term(t -\> t  
.field("product")  
.value("product name"));

queryBuilder.withAggregation("sum\_agg",AggregationBuilders.sum(builder -\> builder.field("price")))

sum aggregation returns sum of all prices in index but i need sum of prices of selected products.

waiting for your prompt response .... thanks

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 9, 2024, 5:35am UTC](https://discuss.elastic.co/t/spring-data-elasticsearch/361089/2 "2024-06-09T05:35:00Z")

</div>

Could you share the full code of this method please?