arangodb/aql update array of documents

Question

Given the following document structure:

{
  "active": "N",
  "code": "AL",
  "id": 3,
  "mcc": "+355",
  "name": "Arango",
  "participant": [
    {
      "actor": {
        "reference": "Patient/example",
        "display": "Peter James Chalmers"
      },
      "required": "required",
      "status": "not booked"
    }
  ]
}

I want to update array of participant[*].status as "not booked" to "booked".

could you tell me the Arango query for update array value.

Answer 1

Here is a solution using an inline projection:

FOR doc IN coll
  FILTER doc._key == "<key>"
  UPDATE doc WITH {
    participant: doc.participant[* RETURN MERGE(CURRENT, {status: "booked"})]
  } IN coll

Note that this sets the status to "booked" for all objects in the participant array.