Azure DocumentDB ARRAY_CONTAINS on nested documents

Question

It seems like the ARRAY_CONTAINS function on nested documents never matches any document.

For example, trying the following simple query with the Azure DocumentDB Query Playground would return no result, even if some nested documents should match this query.

SELECT *
FROM food
WHERE ARRAY_CONTAINS(food.tags.name, "blueberries")

This past question on Stack Overflow also infered that this kind of nested query is valid.

Thank you

Answer 1

The first argument to ARRAY_CONTAINS must be an array. For example, in this case food.tags is valid as an argument, but food.tags.name is not.

Both the following DocumentDB queries are valid and might be what you're looking for:

SELECT food
FROM food
JOIN tag IN food.tags
WHERE tag.name = "blueberries"

Or

SELECT food
FROM food
WHERE ARRAY_CONTAINS(food.tags, { name: "blueberries" })