Cannot perform append and update on an array within the same n1ql request

UPDATE `users`
SET logs.sessions = ARRAY CASE WHEN s.fingerprint = "xxxx" AND s.closed = false THEN OBJECT_PUT(s,"closed",true) ELSE s END
    s.closed = true FOR s IN logs.sessions WHEN s.fingerprint = "xxxx" AND s.closed = false END
WHERE credentials.email = "user@email.com";
1 Like