Cosmos Db - search on value from array

Question

Using a query for Cosmos, how do I select out all Roles that have an ID of '11'?

{
   "Roles":[
      {
         "Name":"Admin",
         "ID":[
            "11",
            "22",
            "33"
         ]
      },
      {
         "Name":"User",
         "ID":[
            "11"
         ]
      }
   ]
}

I think it sort of looks like this but not sure about the where clause...

select value r from c join r in c.Roles join i in r.ID // where i = ??

Steve Johnson · Accepted Answer · 2020-07-22 01:18:40Z

1

Please try something like this:

select value r from c join r in c.Roles where ARRAY_CONTAINS(r.ID,'11',false)

Hope this can help you:).

answered Jul 22, 2020 at 1:18

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 Db - search on value from array

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