Azure doc db nested query

Question

I have document schema like below in my collection

{
......
    Message :
    {
       Content : "E$XCV&*",
       Vehicles : [
         {
           Status : "",
           VehicleId : "veh1",
           ........
         },
         {
           Status : "",
           VehicleId : "veh2",
           ........
         },
         {
           Status : "",
           VehicleId : "veh1",
           ........
         },
         ............
       ]
    }
}

I need to update status for particular vehicle id.

Jesse Carter · Accepted Answer · 2017-07-14 13:54:15Z

1

CosmosDb doesn't have a convenient client side API for modifying a specific property of a document like this. You need to retrieve the document and make the modification and then use Upsert to put the newly updated document in it's place.

Alternatively, you can do it on the server side using CosmosDb Stored Procedures which would allow to modify the doc in place.

answered Jul 14, 2017 at 13:54

Jesse Carter

21.3k8 gold badges71 silver badges105 bronze badges

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

1 Comment

Pritam Over a year ago

True.. Finally I came up with a stored proc.. Thanks to ARRAY_CONTAINS() of doc db.

Collectives™ on Stack Overflow

Azure doc db nested query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related