MongoDB - How to update a specific property of a nested array element

Question

I have a collection with the following structure:

{
  arrangements: [
    { displayName: "MRT.8" },
    { displayName: "MRT.10" },
    { displayName: "MRT.12" },
    (...)
  ]
}

I want the substring MRT to be replaced with MOBILE, so the result will be as follows:

{
  arrangements: [
    { displayName: "MOBILE.8" },
    { displayName: "MOBILE.10" },
    { displayName: "MOBILE.12" },
    (...)
  ]
}

Following the solution for a similar problem on SO I did the following:

db.collection('releaseDocument').updateMany({"arrangements.displayName": {$regex: /MRT\..*/}}, [
      {
        $set: {
          'arrangements.displayName': {
            $concat: [
              "MOBILE.",
              {$arrayElemAt: [{$split: ["$displayName", "MRT."]}, 0]}
            ]
          }
        }
      }
    ])

But that doesn't work because $ refers to the current document, not the nested array element. How can I achieve what I described above?

Yong Shun · Accepted Answer · 2022-05-03 07:31:01Z

1

Seems you are working with Update with Aggregation Pipeline, you need $map operator.

For $arrayElementAt part, I think you need 1 as an index to take the second element.

Assume that the filter returns documents to be updated:

db.collection.update({
  "arrangements.displayName": {
    $regex: /MRT\..*/
  }
},
[
  {
    $set: {
      "arrangements": {
        $map: {
          input: "$arrangements",
          in: {
            $mergeObjects: [
              "$$this",
              {
                displayName: {
                  $concat: [
                    "MOBILE.",
                    {
                      $arrayElemAt: [
                        {
                          $split: [
                            "$$this.displayName",
                            "MRT."
                          ]
                        },
                        1
                      ]
                    }
                  ]
                }
              }
            ]
          }
        }
      }
    }
  }
])

Sample Mongo Playground

answered May 3, 2022 at 7:31

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

1 Comment

tiefenauer Over a year ago

just what I needed. I didn't know the $$this operator only works when using $map. And you were right about using 1 as the index, too

Collectives™ on Stack Overflow

MongoDB - How to update a specific property of a nested array element

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related