Hi I’m new to N1QL, can anyone help me with update query.
Below is the document structure.
{
"id" : "0123",
"arr1" [
{
"number" : 1,
"name" : "abc"
},
{
"number" : 2,
"name" : "def"
},
{
"number" : 3,
"name" : "ghi"
}
] ,
"arr2" [
{
"number" : 4,
"name" : "xyz"
}
]
}
Want to move 2 objects from arr1 (with id 2,3) to arr2.
Final Output :
{
"id" : "0123",
"arr1" [
{
"number" : 1,
"name" : "abc"
}
] ,
"arr2" [
{
"number" : 4,
"name" : "xyz"
},
{
"number" : 2,
"name" : "def"
},
{
"number" : 3,
"name" : "ghi"
}
]
}