Update Query - Using work bench - One time job

SQL++
1

Hi CB Team,
I want to update one field in my array document to “02” , but some how condition throwing an error.
Can, you help…?
Note : I have index on orderType

Query :

UPDATE ORDER_INT t
SET er.type=“02” FOR er IN t.OdersRecords
WHERE t.docType=“ordersellmaintain”
END

document
{
“OdersRecords”: [
{
“type”: “01”,
“startDate”: “2020-09-01”,
}
],
“orderType”: “ordersellmaintain”,
}

2 
UPDATE ORDER_INT t
SET er.type="02" FOR er IN t.OdersRecords END
WHERE t.docType="ordersellmaintain"

END is at wrong place. Syntax diagram

3

Thank you always confuse with END