Update unique nested array element in Mongodb

Question

I have a very simple example from official documentation page:

Data:

   { item: "journal", instock: [ { warehouse: "A", qty: 5 }, { warehouse: "C", qty: 15 } ] },
   { item: "notebook", instock: [ { warehouse: "C", qty: 5 } ] },
   { item: "paper", instock: [ { warehouse: "A", qty: 60 }, { warehouse: "B", qty: 15 } ] }

I want to update quantity where item = "journal" and warehouse = "A".

Item is always unique, warehouse is always unique within array elements.

For example I tried queries like this:

collection.updateOne(
"{ \"item\": \"" + item + "\", \"instock.warehouse\": \"" + warehouse + "\" } } }", // find
"{ $set: { quantity: \"" + quantity + "\" } }" // update
)

Issue is always the query, for example this query returns all elements... I tried about 100 different other ones but nothing is working.

I am using embedded db for tests right now from flapdoodle, version 3_4.

@Gibbs works, thanks a lot! I left a comment but seems it was deleted. — luka_roves
– luka_roves, Commented May 7, 2022 at 7:12

Gibbs · Accepted Answer · 2022-05-05 07:44:13Z

1

You need to use positional operator

Playground

db.collection.update({
"instock.warehouse": "C",
  "item": "journal"
},
{
  $set: {
    "instock.$.qty": 10
  }
})

answered May 5, 2022 at 7:44

Gibbs

23.1k14 gold badges84 silver badges147 bronze badges

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

Collectives™ on Stack Overflow

Update unique nested array element 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