Update value inside array of object in mongoose

Question

I have a notification schema in mongoose:

var mongoose = require('mongoose');
var schema = mongoose.Schema;

var notificationSchema = new schema({
    createdOn:{type: Date, default: Date.now},
    createdBy:{type: String, required:true},
    sentTo:{type: Array, required:true},
    content:{type:Object}
});



module.exports = mongoose.model('notification',notificationSchema);

data would be like this :

{
        "_id" : ObjectId("6350dee274edf5586dc86099"),
        "sentTo" : [
            {
                "username" : "user1",
                "status" : 0
            },
            {
                "username" : "user2",
                "status" : 0
            },
            {
                "username" : "user3",
                "status" : 0
            },
            {
                "username" : "user4",
                "status" : 0
            }
        ],
        "status" : 0,
        "createdOn" : ISODate("2022-10-20T05:38:42.656Z"),
        "createdBy" : "system",
        "content" : {
            "text" : "This is content"
        }

    }
{
        "_id" : ObjectId("6350dee274edf5586dc86099"),
        "sentTo" : [
            {
                "username" : "user1",
                "status" : 0
            },
            {
                "username" : "user3",
                "status" : 0
            }
        ],
        "status" : 0,
        "createdOn" : ISODate("2022-10-20T05:38:42.656Z"),
        "createdBy" : "system",
        "content" : {
            "text" : "This is another content"
        }

    }

Now i want to update status of all notification whose username = user3 to 1

status values

0 -> new

1 -> seen

2 -> read

Now new document should look like this

{
        "_id" : ObjectId("6350dee274edf5586dc86099"),
        "sentTo" : [
            {
                "username" : "user1",
                "status" : 0
            },
            {
                "username" : "user2",
                "status" : 0
            },
            {
                "username" : "user3",
                "status" : 1
            },
            {
                "username" : "user4",
                "status" : 0
            }
        ],
        "status" : 0,
        "createdOn" : ISODate("2022-10-20T05:38:42.656Z"),
        "createdBy" : "system",
        "content" : {
            "text" : "This is content"
        }

    }
{
        "_id" : ObjectId("6350dee274edf5586dc86099"),
        "sentTo" : [
            {
                "username" : "user1",
                "status" : 0
            },
            {
                "username" : "user3",
                "status" : 1
            }
        ],
        "status" : 0,
        "createdOn" : ISODate("2022-10-20T05:38:42.656Z"),
        "createdBy" : "system",
        "content" : {
            "text" : "This is another content"
        }

    }

what can be the query : As of now my query is :

let filters = {};
let updateObj = {};
filters['sentTo.username'] = "user3";
filters['sentTo.status'] = {$lt: 2} //only update whose status is less than 2
updateObj['sentTo.$.status'] = 1;

Notification.updateMany(filters, updateObj, function (err, doc) {
     if(err){
          console.log(err)
     }
})

but above query is updating the status of 1st element of the array.

NeNaD · Accepted Answer · 2022-10-20 06:39:42Z

1

You can do it with $elemMatch and positional operator - $:

db.collection.update({
  "sentTo": {
    "$elemMatch": {
      "username": "user3",
      "status": {
        "$lt": 2
      }
    }
  }
},
{
  "$set": {
    "sentTo.$.status": 1
  }
},
{
  "multi": true
})

Working example

edited Oct 20, 2022 at 6:39

answered Oct 20, 2022 at 6:18

NeNaD

20.8k11 gold badges65 silver badges119 bronze badges

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

3 Comments

kuldeep gupta Over a year ago

I did the same but it's not working as you can see in question i already mentioned there my solution in mongoose. One more thing , there is also a filter with status < 2

NeNaD Over a year ago

Oh sorry, didn't see the filter. Then you have to use $elemMatch. I updated my answer. Can you try it again?

kuldeep gupta Over a year ago

Thank you sir!. $elemMatch was missing in my query.

Collectives™ on Stack Overflow

Update value inside array of object in mongoose

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related