Problem with updating nested array of object in mongodb

Question

I am trying to update a field in nested array object, but the field is not getting updated.

I need to update the comment field and I am using the below query to update it, using mongoose,

let updateComment = await StoryComment.update({ _id: this.req.body.commentId, 'comments.reply.userId': currentUser, 'comments.reply._id': this.req.body.replyId }, { $set:{ 'reply.$.comment': replyData } }, { new: true, 'safe': true, 'upsert': true });

can anyone help me to fix this issue, it looks right but its not getting updated

Arvind Pal · Accepted Answer · 2021-07-21 13:18:37Z

1

Try following, this might meet your requirement

   let updateComment = await StoryComment.updateOne(
      {
        _id: mongoose.Types.ObjectId(this.req.body.commentId), 
      },
      {
        $set:{ 
          "comments.reply.$[el].comment": replyData 
          
        }
      },
      {
        arrayFilters:[{
          "el._id":mongoose.Types.ObjectId(this.req.body.replyId) 
        }],
        new: true
      }
    )

answered Jul 21, 2021 at 13:18

Arvind Pal

5213 silver badges16 bronze badges

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

Comments

Rajdeep D · Accepted Answer · 2021-07-21 12:11:32Z

0

Please try this

{ $set:{ 'comments.reply.$.comment': replyData } }

answered Jul 21, 2021 at 12:11

Rajdeep D

3,9201 gold badge12 silver badges18 bronze badges

4 Comments

Rajdeep D Over a year ago

Is this doing insert all the time?

Nick Over a year ago

its always updating a specific one although the reply._id is different

Rajdeep D Over a year ago

I guess it's always updating the first reply. You can check with find what document are you getting back as you are running on comments collection that will always return `comment' document only

Nick Over a year ago

let me try the find option

Collectives™ on Stack Overflow

Problem with updating nested array of object in mongodb

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related