Extacting only one element from a nested array of objects, where the object satisfies property

[vsr1]

UPDATE db AS e 
SET c.prcoess.firstName = "xyz" FOR c IN e.aCtxList  WHEN c.process.id = "b99099fc-fb50-408d-a506-388493fd4d46"  END
WHERE  ANY v IN e.aCtxList  SATISFIES v.process.id = "b99099fc-fb50-408d-a506-388493fd4d46" END;

Check syntax diagram of UPDATE (update-for FOR ARRAYS ) posted below link

UPDATE SET FOR IN WHEN END chain

Thanks vsr1, here is the truncated form of the “hotel_10063” doc in the standard travel-sample bucket after I successfully ran the first UPDATE statement, which inserted the attribute “aaa” array of objects to the second object under the “reviews” array. I am trying to change the string value of the “bbb” attribute located in the second object in the “aaa” array where the “id” attribute equals “b2”. I am having a hard time following the very last example on the link I originally posted that …

Last example:

UPDATE | Couchbase Docs