Question

An e-commerce container stores order documents where each order has a nested array named 'items', with each item containing a 'category' field. A developer needs a query that returns one row per order-item combination, filtered to only items where category = 'Electronics', so downstream reporting can list each electronics line individually. Which SQL query correctly accomplishes this in Azure Cosmos DB for NoSQL?

Accepted Answer

SELECT o.id, i.category FROM orders o JOIN i IN o.items WHERE i.category = 'Electronics'

Answer

SELECT o.id, o.items.category FROM orders o WHERE o.items.category = 'Electronics'

Answer

SELECT o.id, i.category FROM orders o WHERE ARRAY_CONTAINS(o.items, 'Electronics')

Answer

SELECT o.id, i.category FROM orders o JOIN orders i WHERE i.category = 'Electronics'