mongodb: how to update multiple fields in a nested array item of a single document

Question

[
  {
    _id: "...",
    title: "some title",
    tasks: [
      { 
        id: "...",
        field1: "abc",
        field2: "def"
      },
      ...
    ]
  },
  ...
]

I would like to modify both field1 and field2 for a given task. I see lots of examples of how to update a single field, but not multiple fields.

I've tried the following, but it's simply replacing the whole task object with only the fields I'm setting.

    let changes = { field1: "123", field2: "456" };

    db.collection("lists")
        .updateOne(
            {   
                "_id": new ObjectId(req.params.listId), 
                "tasks.id": req.params.id 
            },
            { $set: { "tasks.$": changes } }
        );

Appreciate any help. Thanks.

WORKING SOLUTION

    let changes = { field1: "123", field2: "456" };
    Object.keys(changes).forEach(key => {
        changes[`tasks.$.${key}`] = changes[key];
        delete changes[key];
    });
    db.collection("lists")
        .updateOne(
            {   
                "_id": new ObjectId(req.params.listId), 
                "tasks.id": req.params.id 
            },
            { $set: changes }
        );

Shubham Dixit · Accepted Answer · 2020-05-02 09:29:20Z

3

You have to follow query something similar like below to update the nested document inside an array. You have to give separate names for field1 and field2.Here is the document link

 db.collection.updateOne(
               {"_id": new ObjectId(req.params.listId),"tasks.id": req.params.id },
               { $set: { "tasks.$.field1":"xyz","tasks.$.field2":"mno" } } )

answered May 2, 2020 at 9:29

Shubham Dixit

9,2685 gold badges32 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

mongodb: how to update multiple fields in a nested array item of a single document

WORKING SOLUTION

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

WORKING SOLUTION

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related