Get objects fields values from array in CosmosDB

Question

I have a query for CosmosDB:

SELECT food.tags FROM food

which returns this:

{
  "tags": [
    {
      "name": "babyfood"
    },
    {
      "name": "dessert"
    },
    {
      "name": "fruit pudding"
    },
    {
      "name": "orange"
    },
    {
      "name": "strained"
    }
  ]
}

I would like to create a query to obtain results like:

["babyFood", "dessert", "fruit pudding", "orange", "strained"]

so my goal is to get an array which will contain values of 'name' field from all objects in 'tags' array.

How could it be done in CosmosDB SQL?

Please help.

juwil · Accepted Answer · 2017-09-18 11:19:01Z

6

SELECT VALUE t.name from f join t in food.tags

with VALUE you do the flattening.

answered Sep 18, 2017 at 11:19

juwil

4663 silver badges11 bronze badges

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

5 Comments

MrPJ Over a year ago

This would return values as separated values not in an array which I want. My solution was to create a User Defined Function in JavaScript and use it in a query.

juwil Over a year ago

actually this will return an array of values. i

juwil Over a year ago

previous edit was not quite done..Actually this will return exactly the array you mentioned above. What kind of result did you get? Or was this just because of the typo in SELECT VALUE t.name from f join t in food.tags, which should be SELECT VALUE t.name from f join t in f.tags

Suyash Gupta Over a year ago

How to get object fields name?

juwil Over a year ago

which object's name do you want to get?

Collectives™ on Stack Overflow

Get objects fields values from array in CosmosDB

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related