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

Aravind Krishna R. · Accepted Answer · 2016-11-18 22:43:42Z

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" })

answered Nov 18, 2016 at 22:43

Aravind Krishna R.

8,00332 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

GeorgCantor Over a year ago

Thank you Aravind, this is what I was looking for :)

GeorgCantor Over a year ago

Maybe it's worth updating your previous answer stackoverflow.com/questions/31022740/… 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.

Aravind Krishna R. Over a year ago

Thanks - I've fixed the previous answer

Collectives™ on Stack Overflow

Azure DocumentDB ARRAY_CONTAINS on nested documents

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related