Query Nested Array in Cosmos DB

Question

I'm new to Cosmos and I am trying to query a nested array. I found this blog on how to work with arrays but there isn't an example on a nested array.

Given this json document, how can I query the Tags array? I want to find all records that have a tag of "test-1" within its Fees array.

{
    "id": "22142846",
    "PartitionKey": 846,
    "Fees": [
        {
            "Tags": [
                "test-1"
            ]
        },
        {
            "Tags": [
                "test-2"
            ]
        }
    ]
}

Why would you have an array with the same name twice vs. having it once with both values? — Mark Brown
– Mark Brown, Commented Jan 17, 2023 at 2:27
Does this answer your question? How to SQL query a nested list and array in a MS Azure CosmosDB? — Imre Pühvel
– Imre Pühvel, Commented Jan 17, 2023 at 7:48

RitikaNalwaya · Accepted Answer · 2023-01-17 15:35:43Z

2

Here is the sample query

SELECT c.id, c.PartitionKey
FROM c
JOIN t IN c.Fees
where array_contains(t.Tags,"test-1")

Here is the result.

enter image description here

Sample Records/Documents used

{
    "id": "22142846",
    "PartitionKey": 846,
    "Fees": [
        {"Tags": ["test-1"]},
        {"Tags": ["test-2"]}
    ]
}


{
    "id": "22142847",
    "PartitionKey": 847,
    "Fees": [
        {"Tags": ["test-1"]},
        {"Tags": ["test-2"]}
    ]
}

{
    "id": "22142848",
    "PartitionKey": 848,
    "Fees": [
       {"Tags": ["test-2"]},
       {"Tags": ["test-3"]}
    ]
}

answered Jan 17, 2023 at 15:35

RitikaNalwaya

5903 silver badges3 bronze badges

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

Collectives™ on Stack Overflow

Query Nested Array in Cosmos DB

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related