Update all objects in a MongoDB document array field

Question

What I'm trying to do

I am trying to update all objects inside a field array in a MongoDB document using mongoose.

What I have

User document

{
 id: <ObjectId>,
 ...
 notifications: [
  {
   commissionId: <ObjectId>
   commissioner: <ObjectId>
   date: ...
   description: "You have a new commission!"
  },
  {
   commissionId: <ObjectId>
   commissioner: <ObjectId>
   date: ...
   description: "You have a new commission!"
  },
 ]
}

What I want to have

{
 id: <ObjectId>,
 ...
 notifications: [
  {
   commissionId: <ObjectId>
   commissioner: <ObjectId>
   date: ...
   description: "You have a new commission!"
   read: true // Add read field with a value of true
  },
  {
   commissionId: <ObjectId>
   commissioner: <ObjectId>
   date: ...
   description: "You have a new commission!"
   read: true // Add read field with a value of true
  },
 ]
}

I am working with mongoose which right now I am using the findByIdandUpdate method. I tried using a method to do this but it just failed.

await User.findByIdAndUpdate(
        args.userId,
        {
          notifRead: true,
          $set: {
            "notifications.$.read": true, // FAIL "The positional operator did not find the match needed 
                                          // from the query."
          },
        },
        {
          new: true,
          runValidators: true,
        }
      );

Is there a way to do this simply?

You can use $[] operator to do that. Check this answer: stackoverflow.com/a/57622658/11711316 — Cuong Le Ngoc
– Cuong Le Ngoc, Commented May 2, 2021 at 6:34

Apoorva Chikara · Accepted Answer · 2021-05-02 06:45:44Z

1

It can be possible using all positional operator $[], you can do this:

await User.update(
        args.userId,
        {
          $set: {
            "notifications.$[].read": true,                             
          },
        },
        {
          muti: true
        }
      );

For more details, you can check here.

edited May 2, 2021 at 6:45

answered May 2, 2021 at 6:38

Apoorva Chikara

8,8033 gold badges24 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Update all objects in a MongoDB document array field

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related