In my case i have a Doc which is a Lead, this lead can have more then one Person and each person can have more then 1 phone number or email. I was able to get the value or the element of a Phone number based on given if of user and phone nbr like this
SELECT p.id,e from default as d
UNNEST d.person p
UNNEST p.email AS e
where p.id = “cc54bfc9-21de-4729-8ebb-b5ffcd6b4850” and e.id = “3416e4cc-89df-4537-b86f-a417614ebe12”
which returns me the data like this which is fine
Now my question is how do i for example update the value of default to '“no” or how can i delete the default elment all together ? Also is there a way to to insert a new doc into the array via N1SQL ?