Query Array with variable key

[atom_yang]

@RV

SELECT a.* FROM testbucket aWHERE “GMC” IN OBJECT_NAMES(OBJECT_VALUES(a.owners).property.cars[*])and ANY obj IN OBJECT_NAMES(a.owners) SATISFIES obj == “ownerABC” END

As you condition that include obj,so you can just get the obj by

SELECT a.owners.ownerABC
FROM testbucket a
WHERE "GMC" IN OBJECT_NAMES(OBJECT_VALUES(a.owners)[].property[].cars[*])
and ANY obj IN OBJECT_NAMES(a.owners) SATISFIES obj == "ownerABC" END

[RV]

Yup, perfect.
Thanks again.