Updated Mongoose update nested array element

Question

I have the following Schema

UserSchema: Schema = new Schema({
  username: String,
  password: String,
  chat: [{
    lastSeen: { type: Date, default: Date.now },
    room: {
        type: Schema.Types.ObjectId, ref: 'ChatRoom'
    }
  }],
});

I wanna make static method to the UserSchema, so that updates chat[i].lastSeen by given room _id

UserSchema.statics.lastSeen = 
function lastSeen(username: string, roomId: number, date: Date) {
   this.update({
    username: username,
    chat: {
        $elemMatch: {
            'room._id': roomId
        }
    }},
    {
        $set: { 'chat.$[???].lastSeen': date}
    });
}

I can't find out how to get the chat element by his element room._id and then update it. Any help?

EDIT

My case is similar but not the same as suggested duplicate, because the guy there knows all ids, where I don't know chat._id.

@JasonCust I read this and couldn't do it. Can you give a code for my specific case? — Petar Dimov, Feb 01 '18 at 19:43

score 12 · Accepted Answer · answered Feb 01 '18 at 21:28

12

I'm posting the solution in case someone needs it.

UserSchema.statics.lastSeen = 
function lastSeen(username: string, roomId: number, date: Date) {
    this.update({
      username: username,
      'chat.room': roomId
    }, { $set: { 'chat.$.lastSeen': date }})
    .exec();
};

answered Feb 01 '18 at 21:28

Petar Dimov

301
2
11

Also works from the Model (e.g. Model.update), no .exec is need in this case – Luiz Fernando da Silva Jan 30 '19 at 17:26

Updated Mongoose update nested array element

1 Answers1

Linked