MongoDB query a document by it's nested array of objects and update all objects inside document's array that matchs query

Question

So I have the following documents in a collection.

{
       _id: "1",
       quantity: 0,
       array: [{name: "test1a", quantity: 10}, {name: "test1a", quantity: 1}, {name: "test1b", quantity: 10}, {name: "test1c", quantity: 1}]
}

{
       _id: "2",
       quantity: 0,
       array: [{name: "test2a", quantity: 10}, {name: "test2b", quantity: 10}, {name: "test2c", quantity: 1}]
}

{
       _id: "3",
       quantity: 0,
       array: [{name: "test3a", quantity: 10}, {name: "test3b", quantity: 10}, {name: "test3c", quantity: 1}]
}

What I wanted was to query all documents in the collection whose it's array contains objects with name = "test1a" and update those object quantity property with a new value.

update with what?

Krishna
– Krishna

2018-03-28 19:38:49 +00:00
Commented Mar 28, 2018 at 19:38 — Krishna
– Krishna, Commented Mar 28, 2018 at 19:38
@Krishna with a new int value using $set operator.

Henrique Borges
– Henrique Borges

2018-03-28 19:42:11 +00:00
Commented Mar 28, 2018 at 19:42 — Henrique Borges
– Henrique Borges, Commented Mar 28, 2018 at 19:42

Graciano · Accepted Answer · 2018-03-28 21:20:03Z

1

Try something like

db.collection.find({"array.name": "test1a"}).forEach(function(doc){       
var myArray = doc.array;
for (var i in myArray){
    if(myArray[i].name == "test1a"){
        myArray[i].quantity = myArray[i].quantity +1;        
    }
}
 db.collection.update({"_id": doc._id},{$set: {"array":myArray}});
});

edited Mar 28, 2018 at 21:20

answered Mar 28, 2018 at 19:38

Graciano

5184 silver badges11 bronze badges

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

2 Comments

Henrique Borges Over a year ago

I received the following error: cannot use the part (array of array.quantity) to traverse the element.

Henrique Borges Over a year ago

The problem is, array.&.quantity only updates the first element inside the array. What I want is to update all array elements that matchs name = "test1a".

Krishna · Accepted Answer · 2018-03-29 02:25:45Z

0

db.test.updateMany(
    { "array.name": "test1a" }, 
    { "$set": { "array.$[elem].quantity": "newvalue" } },
    { "arrayFilters": [{ "elem.name": "test1a" }] }
)

edited Mar 29, 2018 at 2:25

answered Mar 28, 2018 at 19:49

Krishna

5493 silver badges14 bronze badges

9 Comments

Henrique Borges Over a year ago

The problem is, array.&.quantity only updates the first element inside the array. What I want is to update all array elements that matchs name = "test1a".

Henrique Borges Over a year ago

I got the following error = cannot use the part (array of array.$[elem].quantity) to traverse the element.

Krishna Over a year ago

did you use arrayfilters option?

Henrique Borges Over a year ago

Yes, I did use arrayFilters option.

Krishna Over a year ago

I tested the query and then posted here. Can you post your full query

|

Collectives™ on Stack Overflow

MongoDB query a document by it's nested array of objects and update all objects inside document's array that matchs query

2 Answers 2

2 Comments

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related