Subdoc mutatein to remove element from array

Node.js SDK
1

Hi,

How can I remove an element using mutatein .
Document is something like this
{
“id”:“456”,
“name”:“srikar”,
“flightname”:“xyz”,
“booking”:[{“bookingid”:""1234,“date”:“2017-05-04”},{“bookingid”:“456789”,“date”:“2017-05-03”} ],
“address”:“wehedwhwe”
}

How can I remove a booking item where bookingid is “456789” using mutatein.

If not can any one suggest me alternative to achieve result.

Regards.
Srikar

1 Like
2

try this

SELECT default.name, default.flightname, default.address ,ARRAY_AGG(book) AS booking
  FROM default USE KEYS ["456"] UNNEST booking book 
 WHERE book.bookingid != "456789"
 GROUP BY default.name, default.flightname, default.address
3

what does ‘default’ stands for , is this bucket name?

4

yes ,you can change it to your bucket name.

5

Thanks,
I tried it is working, but I need to update(removing particular booking item) database, which was not happening with select.

Can you please help me with update query. no need of returning results back.

6

FYI

UPDATE default USE KEYS ["456"]
   SET booking = ARRAY book 
   FOR book IN booking WHEN book.bookingid != "456789" END 
RETURNING *;

more detail, FYI

2 Likes