Elasticsearch Scripting: updating array value

Question

This is my document

{
    "name": "andrew",
    "b": [{"x":"c1", "y": 0}, {"x":"c2", "y": 0}]
}

I want to find element in the array field "b" and update the entire object. I tried this script but it does not update. Any ideas?

{
    "script": "for (item in ctx._source.b) { if (item['x'] == x_id) { item = newobj; } };",
    "params": {
        "x_id": "c1",
        "newobj" : {"x":"c1", "y": 4222}
    },
    "lang":"groovy"
}

score 13 · Accepted Answer · answered Jun 08 '16 at 20:57

13

Use this instead:

{
  "script": "for (int i=0;i<ctx._source.b.size();i++) { item=ctx._source.b[i]; if (item['x'] == x_id) { ctx._source.b[i] = newobj} };",
  "params": {
    "x_id": "c1",
    "newobj": {
      "x": "c1",
      "y": 4222
    }
  },
  "lang": "groovy"
}

answered Jun 08 '16 at 20:57

Andrei Stefan

51,654
6
98
89

what to use update API or update query API while executing ? – Rahul Patel Aug 16 '18 at 06:34
I hope update API works, If you want to update many docs using query you have to use update query API – Manonandan S K Sep 11 '22 at 14:23

Elasticsearch Scripting: updating array value

1 Answers1

Linked