Query Array with variable key

SQL++
,
2

you can create index by:

CREATE INDEX `idx_obj_names` ON `default`(DISTINCT ARRAY obj FOR obj IN OBJECT_NAMES(owners) END) USING GSI;

And you can use the N1QL

SELECT a.* FROM default a WHERE ANY obj IN OBJECT_NAMES(a.owners) SATISFIES obj == "ownerABC" END
2 Likes