Mongodb Update subdocument values matching subdocument and without altering other fields

Question

I have a schema like this

{
    "_id": "5f86da4b5bb9a62742371409",
    "status" : true,
    "doc": [
      {
        "_id": "5f86cacbe4d7c423f21faf50",
        "a": 4,
        "b": null
      },
      {
        "_id": "5f86cb01a1ca5124063299c1",
        "a": 6,
        "b": null

      }
    ]
}

And I have an update in the form of


[
      {
        "_id": "5f86cacbe4d7c423f21faf50",
        "b": 90
      },
      {
        "_id": "5f86cb01a1ca5124063299c1",
        "b": 45

      }
    ]

How can I update the collection to end up like this?

{
    "_id": "5f86da4b5bb9a62742371409",
    "status" : true,
    "doc": [
      {
        "_id": "5f86cacbe4d7c423f21faf50",
        "a": 4,
        "b": 90
      },
      {
        "_id": "5f86cb01a1ca5124063299c1",
        "a": 6,
        "b": 45

      }
    ]
}

Basically I want to update the subdocument with specific keys only (leaving other keys intact)

turivishal · Accepted Answer · 2020-10-15 04:04:00Z

1

You can use update with aggregation pipeline from MongoDB 4.2,

$map to iterate loop of array doc and inside it iterate through updateDocs array, it will return matching b, and then $mergeObjects will return updated document,

let updateDocs = [
  { "_id": mongoose.Types.ObjectId("5f86cacbe4d7c423f21faf50"), "b": 90 },
  { "_id": mongoose.Types.ObjectId("5f86cb01a1ca5124063299c1"), "b": 45 }
];

db.collection.updateMany({},
[
  {
    $set: {
      doc: {
        $map: {
          input: "$doc",
          as: "d",
          in: {
            $mergeObjects: [
              "$$d",
              {
                $reduce: {
                  input: updateDocs,
                  initialValue: {},
                  in: {
                    $cond: [
                      { $eq: ["$$this._id", "$$d._id"] },
                      { b: "$$this.b" },
                      "$$value"
                    ]
                  }
                }
              }
            ]
          }
        }
      }
    }
  }
]
)

Playground

edited Oct 15, 2020 at 4:04

answered Oct 14, 2020 at 11:41

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

3 Comments

niksmac Over a year ago

Doesn't seems to be working in my actual dataset, but thanks anyway. It gave me some idea. ibb.co/S03yRmB

turivishal Over a year ago

You need to pass ObjectId, currently its string just wrap it ObjectId("5f86cacbe4d7c423f21faf50") and then try.

niksmac Over a year ago

btw, you are missing an array wrapper [] around your $set without it it won't update the database.

Collectives™ on Stack Overflow

Mongodb Update subdocument values matching subdocument and without altering other fields

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