# Elastic Search \_update\_by\_query
**URL:** https://discuss.elastic.co/t/elastic-search-update-by-query/130799
**Category:** Elasticsearch
**Created:** [May 7, 2018, 8:39am UTC](https://discuss.elastic.co/t/elastic-search-update-by-query/130799 "2018-05-07T08:39:39Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@surajdalvi](https://discuss.elastic.co/u/surajdalvi)
#### Post date: [May 7, 2018, 8:39am UTC](https://discuss.elastic.co/t/elastic-search-update-by-query/130799/1 "2018-05-07T08:39:40Z")
Hi
I am using \_update\_by\_query in following way:
> ```
> POST /documents/_update_by_query
> {
> "script":{
> "source":"for(int i = 0;i < ctx._source.fields.size();i++){for (int j = 0; j < params.field_uid.size();j++){ if(params.field_uid[j].type == \"group\"){ } else{ if(ctx._source.fields[i].uid == params.field_uid[j].uid){ ctx._source.fields.remove(i);} } }}",
> "params":{
> "field_uid":[{"uid":"number","type":"number"},{"uid":"test","type":"group"}]
> }
> },
> "query": {
> "term": {
> "name": "first"
> }
> }
> }
>
> ```
It is giving me following error:
> ```
> {
> "error": {
> "root_cause": [
> {
> "type": "script_exception",
> "reason": "compile error",
> "script_stack": [
> "... s.field_uid.size();j++){ if(params.field_uid[j].ty ...",
> " ^---- HERE"
> ],
> "script": "for(int i = 0;i < ctx._source.fields.size();i++){for (int j = 0; j < params.field_uid.size();j++){ if(params.field_uid[j].type == \"group\"){ } else{ if(ctx._source.fields[i].uid == params.field_uid[j].uid){ ctx._source.fields.remove(i);i--;} } }}",
> "lang": "painless"
> }
> ],
> "type": "script_exception",
> "reason": "compile error",
> "script_stack": [
> "... s.field_uid.size();j++){ if(params.field_uid[j].ty ...",
> " ^---- HERE"
> ],
> "script": "for(int i = 0;i < ctx._source.fields.size();i++){for (int j = 0; j < params.field_uid.size();j++){ if(params.field_uid[j].type == \"group\"){ } else{ if(ctx._source.fields[i].uid == params.field_uid[j].uid){ ctx._source.fields.remove(i);i--;} } }}",
> "lang": "painless",
> "caused_by": {
> "type": "illegal_argument_exception",
> "reason": "Extraneous if statement."
> }
> },
> "status": 500
> }
>
> ```
Can anyone help me into this?
What is wrong here?
---
### Author:  [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)
#### Post date: [May 11, 2018, 3:21pm UTC](https://discuss.elastic.co/t/elastic-search-update-by-query/130799/2 "2018-05-11T15:21:30Z")
That's how your script look like:
```auto
for(int i = 0;i < ctx._source.fields.size();i++) {
for (int j = 0; j < params.field_uid.size();j++) {
if(params.field_uid[j].type == "group") {
}
else {
if(ctx._source.fields[i].uid == params.field_uid[j].uid) {
ctx._source.fields.remove(i);
}
}
}
}
```
It complains about the first empty if statement.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 8, 2018, 3:21pm UTC](https://discuss.elastic.co/t/elastic-search-update-by-query/130799/3 "2018-06-08T15:21:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.