How to update values in array using n1q1

Question

My couchbase bucket document looks like below

{
"Records": 
 [
    {
      "record_id": "21",
      "amount": 10,
      "count": 2
    },
    {
      "record_id": "22",
      "amount": 30,
      "count": 3
    }
 ],
"overall_amount": 40,
"overall_count": 5
}

I want to write a n1q1 update query which will update the count value inside Records array. If I update 1st object count from 2 to 5, then I want the overall_count value to get updated to 8.

Expected document should look like below when count increased from 2 to 5

{
"Records": 
[
   {
     "record_id": "21",
     "amount": 10,
     "count": 5
   },
   {
     "record_id": "22",
     "amount": 30,
     "count": 3
   }
],
"overall_amount": 40,
"overall_count": 8
}

How to achieve this?

Answer 1

UPDATE default AS d 
SET a.`count` = a.`count` + 3  FOR a IN d.Records WHEN a.record_id = "21" END,
    d.overall_count = d.overall_count + ARRAY_SUM(ARRAY 1 FOR v IN d.Records WHEN v.record_id = "21" END) * 3 
WHERE ......;

OR

UPDATE default AS d 
SET d.Records[0].`count` = 5 ,
    d.overall_count = 8
WHERE ......;