This is my collection structure in MongoDB:
{ _id: id, name: name, loans: [ [{id: 1, acName: "ABC"}], [{id: 2, acName: "DEF"}], [{id: 3, acName: "GHI"}] ]}How can I updateacName of a specific ID? Let's say, I want to updateacName ofid 2. How can I do that?
1 Answer1
Solution 1: Without arrayFilters
Use
$elemMatchto find the existence ofid: 2in nested arrays.With all positional operator (
$[]) to update the respective document field.
db.collection.update({ "loans": { $elemMatch: { $elemMatch: { id: 2 } } }},{ $set: { "loans.$.$[].acName": "<NEW VALUE>" }})Demo Solution 1 @ MongoPlayground
Solution 2: With arrayFilters
Use
$elemMatchto find the existence of id: 2 in nested arrays.With filtered positional operator (
$[<identifier>]) and arrayFilters to update the respective document field.
db.collection.update({ "loans": { $elemMatch: { $elemMatch: { id: 2 } } }},{ $set: { "loans.$.$[loan].acName": "<NEW VALUE>" }},{ arrayFilters: [ { "loan.id": 2 } ]}) Sign up to request clarification or add additional context in comments.
4 Comments
Rashel
Great. Thanks. It works. Could you please do me another favor? Let's say, my loans is like this: loans: [ [{id: 1, acName: "ABC"}, {id: 4, acName: "KKK}], [{id: 2, acName: "DEF"}, {id: 5}, acName: "MMM"], [{id: 3, acName: "GHI", {id: 6, acName: "NNN"}}] ] How would I be able to change acname of id 2 ?
Rashel
It worked as well. Highly appreciated. Please please don't mind. What if I need to update all acName together depnding on category? loans: [ [{id: 1, acName: "ABC", category: "good"}, {id: 4, acName: "KKK", category: "bad"}], [{id: 2, acName: "DEF", category: "good"}, {id: 5, acName: "MMM", category: "good"}], [{id: 3, acName: "GHI", category: "bad"}, {id: 6, acName: "NNN", category: "bad"}}] ] I will not ask question again. I apologize for repetitive questions.
Explore related questions
See similar questions with these tags.