When I am trying to update just “title”, it is working fine, but if I am trying to update the nested object in the array, it is not working.
Data: Data
Working:
const restaurant = await Restaurant.update( {_id: '60e6828e4992a2979fa0ba3e'}, {$set: {title: "Hello}}, );
Not working:
const restaurant = await Restaurant.update( {_id: '60e6828e4992a2979fa0ba3e', 'grades.grade': 85}, {$set: {'grades.$.grade': 0}}, );
Advertisement
Answer
Demo – https://mongoplayground.net/p/caFBz-lx8dQ
Use $[]
The filtered positional operator $[] identifies the array elements that match the arrayFilters conditions for an update operation
db.collection.update( {}, { $set: { "grades.$[elem].grade": 0 }}, { arrayFilters: [ {"elem.grade": 85 } ]} )