Hi I’m new to N1QL, can anyone help me with update query
Below is the document structure.
{
"id" : "0123",
"subjects: {
"maths":{
"marks" :[{
"First" : 34,
"Second" : 56
}
]
},
"science":{
"marks" :[{
"First" : 54,
"Second" : 76
}
]
}
}
}
Want to update the Second field in marks (array of objects) in subject Object whenever it is maths.