try this pls; ANY will ensure to return the document when 1 of the items in the “list” satisfies your lookupID
FROM server-bucket-name AS blacklist
AND ANY blacklisted IN blacklist.list
SATISFIES blacklisted.lookupID = “U-53267” END;
It’s the same thing when I use “ANY” on the tutorial bucket as well (which is the same thing that happens here), all results are returned, using “EVERY” just returns the desired resultset (only in tutorial bucket on sandbox and N1QL Query Tutorial site).
if you want to only return a subset of the array you need to use unnest. can you assemble the restul of the statement you’d like to see and we can work backwards from the result to construct the query.
I guess I’m just a little confused and don’t really understand the language well.
Had to go back and read statement you made earlier “ANY will ensure to return the document when 1 of the items in the “list” satisfies your lookupID”.
Meaning the * in the SELECT statement is what’s returning the whole document despite the fact that it satisfies my lookupID. So going by your recent statement to unnest, I ran the query below and got the desired results
FROM server-bucket-name b