# Update doc using aggretaion result

**URL:** <https://discuss.elastic.co/t/update-doc-using-aggretaion-result/98642>\
**Category:** Elasticsearch\
**Created:** [August 29, 2017, 7:42am UTC](https://discuss.elastic.co/t/update-doc-using-aggretaion-result/98642 "2017-08-29T07:42:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ravi\_Randev\_Singh](https://avatars.discourse-cdn.com/v4/letter/r/b19c9b/32.png) [@Ravi\_Randev\_Singh](https://discuss.elastic.co/u/Ravi_Randev_Singh)\
**Post date:** [August 29, 2017, 7:42am UTC](https://discuss.elastic.co/t/update-doc-using-aggretaion-result/98642/1 "2017-08-29T07:42:15Z")

</div>

Hi Everyone,

I want to know is there a way to update doc with result of the aggregation, something like this

POST /index/type/\_update\_by\_query  
{  
"query":{  
"match\_all": {}  
},  
"aggs" : {  
"count\_years" : {"cardinality" : {"field" : "costYear"}},  
"max\_costYear" : { "max" : { "field" : "costYear" } },  
"min\_costYear" : { "min" : { "field" : "costYear" } }  
},  
"script":{  
"inline":"ctx.\_source.val1=aggs.count\_years \* value", //something like this what i want  
"lang":"javascript" ,  
"params":{  
"value":"5"  
}  
}  
}

Thanks for any help/ suggestion

---

<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 26, 2017, 7:42am UTC](https://discuss.elastic.co/t/update-doc-using-aggretaion-result/98642/2 "2017-09-26T07:42:18Z")

</div>

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