# Elasticsearch script to modify value inside array

**URL:** https://discuss.elastic.co/t/elasticsearch-script-to-modify-value-inside-array/45568
**Category:** Elasticsearch
**Created:** [March 28, 2016, 8:37am UTC](https://discuss.elastic.co/t/elasticsearch-script-to-modify-value-inside-array/45568 "2016-03-28T08:37:44Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![gpong](https://avatars.discourse-cdn.com/v4/letter/g/d6d6ee/32.png) [@gpong](https://discuss.elastic.co/u/gpong)
#### Post date: [March 28, 2016, 8:37am UTC](https://discuss.elastic.co/t/elasticsearch-script-to-modify-value-inside-array/45568/1 "2016-03-28T08:37:44Z")

</div>

Hi guys,

I am new on elasticsearch script. On my source, I have dn\_list which is json array. and I tried to manipulated the value using script. here is what I want , when user add the dn\_list data I need to subtract dn\_qty (on dn\_no is N/A array) with new dn\_qty. here is my source :  
`{ "sto_no":"3000000168", "line":"10", "shipway":"SF", "hub_location":"F600-HHN1", "delivery_date":"2016-03-10", "order_qty":"2000", "dn_list":[{ "dn_no":"N/A", "dn_shipway":"N/A", "dn_status":"N/A", "dn_qty":"100" }] }`

so for example when user insert this record  
{  
"dn\_no":"87001236",  
"dn\_shipway":"SF",  
"dn\_delivery\_date":"2016-03-16",  
"dn\_status":"DN Released",  
"dn\_qty":"30"  
}

the result will be  
`{ "sto_no":"3000000168", "line":"10", "shipway":"SF", "hub_location":"F600-HHN1", "delivery_date":"2016-03-10", "order_qty":"2000", "dn_list":[{ "dn_no":"N/A", "dn_shipway":"N/A", "dn_status":"N/A", "dn_qty":"70" ---> from 100-30=70 }, { "dn_no":"87001236", "dn_shipway":"SF", "dn_delivery_date":"2016-03-16", "dn_status":"DN Released", "dn_qty":"30" }] }`

is it possible to do this using script??

Thanks a lot

---

<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: [July 5, 2017, 11:04pm UTC](https://discuss.elastic.co/t/elasticsearch-script-to-modify-value-inside-array/45568/2 "2017-07-05T23:04:46Z")

</div>


