I have a phones array which has now number key which is empty. I am wondering how i can i remove the object from array when a certain condition is meet. I can update the object in array but not sure how i would delete the object completly.
UPDATE Contacts c
SET e.`number` = '' FOR e IN c.phones WHEN e.`number` is missing END
where c._type= "farm" AND ANY e IN c.phones SATISFIES e.`number` is Missing END;
this is what i used to find all objects in any of my farm docs where the number was missing and i created an empty string. How would i change this to instead delete the object. I know i can UNSET a key but how does that work with a complete object ?