How update my objects in a document's array in mongoDB

Question

i have the following collection, I have one question about:

{
    "_id" : ObjectId("123456789"),
    "user_id" : 123456,
    "total" : 100,
    "items" : [
            {
                    "item_name" : "my_item_one",
                    "price" : 30
            },
            {
                    "item_name" : "my_item_two",
                    "price" : 30
            },
            {
                    "item_name" : "my_item_three",
                    "price" : 30
            }
    ]
}

how i can update all price concurrently, (price=50 in all objects) thanks for help

Which language or connector are you using

Ogoh.cyril
– Ogoh.cyril

2021-10-16 23:12:41 +00:00
Commented Oct 16, 2021 at 23:12 — Ogoh.cyril
– Ogoh.cyril, Commented Oct 16, 2021 at 23:12

sidgate · Accepted Answer · 2021-10-17 01:52:54Z

1

You can use positional all operator to update all elements in the array

db.collectionName.update(
   { },
   { $set: { "items.$[].price" : 50 } },
   { multi: true }
)

answered Oct 17, 2021 at 1:52

sidgate

15.3k12 gold badges76 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

How update my objects in a document's array in mongoDB

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