Select value from array of objects Cosmos DB

Question

I have the following json

{
"car-id": "54-38ncv",
"cars": [
{
"name": "Ferrari",
"horse-powers": 400
},
{
"name": "BMW",
"horse-powers": 200
},
{
"name": "Audi",
"horse-powers": 145
}]
}

the id is custom set by me. Imagine that there are hundreds other documents in my azure cosmos db collection. I want to create query that selects the first document that has a car in the cars that is named etc. "Ferrari". I know that they are maybe a dublicates, but is want the first one. Is there a quarry for this.

Sajeetharan · Accepted Answer · 2020-02-04 14:33:38Z

1

You can do this,

SELECT TOP 1 FROM c JOIN cc IN c.cars WHERE cc.name IN ("Ferrari")

answered Feb 4, 2020 at 14:33

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

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

2 Comments

hoakey Over a year ago

Great. I was overcomplicating the solution!

Sajeetharan Over a year ago

mark if the answer helped

Collectives™ on Stack Overflow

Select value from array of objects Cosmos DB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related