I am trying to find a way of conditionally removing elements from a JsonArray using UPDATE with UNSET. I’m wondering if my approach may be off here. As an example, I have a document called “theDatabase”: { “id”: “1256”, “theArray”: [ { “field1”: “this”, “field2”: “that”, “field3”: “the”, …

Removing elements in a JsonArray

geraldss January 30, 2015, 10:09am 2

UPDATE default USE KEYS "theDatabase"
SET theArray = ARRAY item FOR item IN theArray WHEN item.field1 IS MISSING END

Topic		Replies	Views
Update nested array of objects (CRUD) SQL++	3	2077	January 30, 2018
Remove a whole 3rd level json array using query Couchbase Server query , n1ql , index	3	1009	April 28, 2020
Update JsonArray document SQL++	6	2677	February 28, 2016
N1QL to remove array elements SQL++	5	5608	April 13, 2017
Update array within a dynamic JSON object. (Removing an element of array nested inside Json object) SQL++ query , n1ql , array-query	3	2154	May 14, 2019