N1QL query to retrieve results based on matching criteria in array

SQL++
5

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

SELECT list
FROM server-bucket-name b
UNNEST b.list
WHERE b.type="blacklist"
AND list.lookupID=“U-53267”;

"results": [
    {
        "list": {
            "blackListedBy": "Jason",
            "entryDateTime": "09172015221459",
            "lookupID": "U-53267",
            "memberID": "M-983-34A",
            "reasonID": "809"
        }
    }
]

Would this be the proper way to extract desired results in cases like this?

Thanks again for your help.