5

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

Community
  • 1
  • 1
GeorgCantor
  • 65
  • 1
  • 7

1 Answers1

6

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" })
Aravind Krishna R.
  • 7,885
  • 27
  • 37
  • Thank you Aravind, this is what I was looking for :) – GeorgCantor Nov 19 '16 at 04:37
  • 1
    Maybe it's worth updating your previous answer http://stackoverflow.com/questions/31022740/documentdb-query-on-nested-document-and-root-level since it is using the ARRAY_CONTAINS function without an array as the first parameter. I do not have enough reputation to comment it directly. – GeorgCantor Nov 19 '16 at 16:00
  • Thanks - I've fixed the previous answer – Aravind Krishna R. Nov 20 '16 at 20:10