How to update an array of documents with an array of values in mongoDB?

Question

I have a collection of Product, the client post and Order request with an array of objects every single object contains the _id product (objectId) and the quantity he bought.

[
{producId: "dshsdsdh72382377923",
quantity: 20
},
{producId: "dsh673sdh72382377923",
quantity: 10
},
{producId: "hjddjkdjkdj676372373",
quantity: 5
},
]

I want to query the Product Collection and decrement (Update) the numberInStock of every product with the quantity that the client bought ! How can i do it ?

Mohammad Basit · Accepted Answer · 2020-09-11 17:09:14Z

1

Build dynamic query based on how many items user purchased. Select the product by it's productId and decrement the quantity by customerValue

let customerValue = 4; // Let's say the customer bought 4 items
let query = {};
query['quantity'] = -customerValue;
db.collection.updateOne(
 {producId : "hjddjkdjkdj676372373"},
 {$inc: query}
);

answered Sep 11, 2020 at 17:09

Mohammad Basit

5758 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

How to update an array of documents with an array of values 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