]
}
UPDATE default SET Bookings = ARRAY book FOR book IN Bookings WHEN NOT STR_TO_MILLIS(book.EndDate) <= STR_TO_MILLIS(“2017-07-19”) END RETURNING Name
I need only the Name of a booking as return value if it is updated, but the above update query is always returning all the booking names no matter whether it is updated or not.
Can any one please suggest what is wrong with the above query.
Returning clause returns qualified mutations as you don’t have any predicate every document qualifies update (in set clause you updating some cases same document with same value).
UPDATE default
SET Bookings = ARRAY book FOR book IN Bookings WHEN book.EndDate > "2017-07-19" END
WHERE ANY book IN Bookings SATISFIES book.EndDate <= "2017-07-19" END
RETURNING Name;
If you want query run faster create following index
CREATE INDEX ix1 ON default( DISTINCT ARRAY book.EndDate FOR book IN Bookings END);