How to update array elements in mongodb

Question

I have data in mongoDB like below

{
  "_id": ObjectId("57c40e405e62b1f02c445ccc"),
  "sharedPersonId": ObjectId("570dec75cf30bf4c09679deb"),
  "notificationDetails": [
     {
       "userId": "57443657ee5b5ccc30c4e6f8",
       "userName": "Kevin",
       "isRed": true 
     } 
   ] 
}

Now i want to update isRed value as false How to write query for this. I have tried something like below

var updateIsRedField = function(db, callback) {
    db.collection('notifications').update({_id:notificationId},
    {
        $set: { "notificationDetails.$": {isRed: false}},
    }, function(err, results) {
        callback();
    });
};

MongoClient.connect(config.database, function(err, db) {
    assert.equal(null, err);
    updateIsRedField(db, function() {
        db.close();
    });
    return res.json({});
});

Can you check the output for db.collection('notifications').find({_id:notificationId})? Is it giving any record or not? — Shrabanee
– Shrabanee, Commented Aug 29, 2016 at 11:42
I am getting result because last time it updates entire notificationDetails array as isRed : false — Kevin
– Kevin, Commented Aug 29, 2016 at 11:46

chridam · Accepted Answer · 2016-08-29 11:42:54Z

3

Since the positional $ operator acts as a placeholder for the first element that matches the query document, and the array field must appear as part of the query document hence the query { "notificationDetails.isRed": true } is essential to get the $ operator to work properly:

db.collection('notifications').update(
    { "_id": notificationId, "notificationDetails.isRed": true },
    { "$set": { "notificationDetails.$.isRed": false } },
    function(err, results) {
        callback();
    }
);

answered Aug 29, 2016 at 11:42

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Collectives™ on Stack Overflow

How to update array elements 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