How to get put data into an Object in an array of objects


#1

Sample code

{
“Cities”: [
{
“citiId”: “3605”,
“aliases”: [],
“CityName”: “ABC”
},
{
“citiId”: “610”,
“aliases”: [],
“CityName”: “CCB”
},
{
“citiId”: “3434”,
“aliases”: [],
“citiName”: “XYz”
}
]
}

So how do you put data into aliases of object where citiName is ‘ABC’. I tried to get the whole object using N1ql, but unable to insert data into that aliases field.

Any help will be appriciated.


#2

UPDATE cities SET aliases = XYZ WHERE citiName = ‘ABC’.