I have document with key collection:31 as following { "userId": 31, "collection": [{ "id":"1b3e4567-e89b-12d3-a456-4nD66u5T40f0p", "impact": 5, "level": 3, "title": "Souvenir", "mate": "RHIO", "beacon": null }, { "id":"48093399-c258-4ea0-a56a-8e0e8631b6ab", "impact": 1, "level…

Update array of object if object exist else insert new object

ashvinipatelap1 October 14, 2016, 5:15am 5

@geraldss yeah I went through array functions and conditional operators and tried some queries but it didn’t work

Sub document update for a nested array document

Topic		Replies	Views
Update Array of object's when object.name is present, if not present add object to Array SQL++	9	3709	May 21, 2020
How to upsert doc with object into array or remove object from array SQL++	1	1176	March 13, 2022
Updating/inserting elements in an sub-document array SQL++	4	1917	August 24, 2022
Update object elements along with child array when object.name exists or else append SQL++ query	1	740	June 21, 2020
Update document which contains Array of object SQL++ n1ql	2	649	June 2, 2022