I have a document like below
{
"runs": {
"run1": {
"result": "pass",
"state": "success"
},
"run2": {
"result": "fail",
"state": "incomplete"
}
}
}
How can I add an object to "runs". object is like below using cbq query?
"run3": {
"result": "pass",
"state": "complete"
}
Did you try an UPDATE ... SET ... N1QL query?
I ran this query:
UPDATE naveen
SET runs.run3 = { "result": "pass", "state" : "complete" }
WHERE META().id = 'doc1';
And the end result document is:
{
"runs": {
"run1": {
"result": "pass",
"state": "success"
},
"run2": {
"result": "fail",
"state": "incomplete"
},
"run3": {
"result": "pass",
"state": "complete"
}
}
}