Cosmos Container SQL API Query

Question

I've a document structure below (simplified):

 {
"id": "2345",
"camp{
    "id": 999
    "code": "C1244
    "offers": [
        {
            "status": "active",
            "description": "Commence Loyalty At Year 6"
        },
        {
            "status": "inactive"
            "description": "abcd test
        }
    }
}

Where I would like to filter the offers where status is active. Can someone help me with what the query may look like for this?

Steve Johnson · Accepted Answer · 2020-07-03 09:46:57Z

1

Please try something like this sql:

SELECT  c.camp.id,c.camp.code,d AS offer FROM c join d in c.camp.offers where d.status = 'active'

Here is the result:

[
    {
        "id": 999,
        "code": "C1244",
        "offer": {
            "status": "active",
            "description": "Commence Loyalty At Year 6"
        }
    }
]

Hope this can help you:).

answered Jul 3, 2020 at 9:46

Steve Johnson

8,8081 gold badge11 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Cosmos Container SQL API Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related