Description
Hi Query team,
a guy in gitter asked for some help and we stumbled across a solution with OBJECT_PAIRS that works fine, but the odd part is that it produces a "value" which seems to be a reserved word.
We fixed it by escaping value:
SELECT customers.* FROM bucketname AS customers WHERE ANY address IN OBJECT_PAIRS(customers.addresses) SATISFIES address.`value`.line1 = '123 any street' END
|
But it seems a little odd that you need to escape something that comes out of a built-in function all the time. has this been considered?
Thanks!
Attachments
Issue Links
- is duplicated by
-
MB-20894 OBJECT_PARIS() creates JOSN document filed as "value" and not able to select that field.
- Closed