regexReplace/replaceAll is not evaluated in update command

[mihaimorcov]

Hey, how can I replace all occurences of a string in a field?
I tried using $replaceAll and $regexReplace and few other commands but the value in the end is an object field with the literal command, not the evaluated regex replace.
Please help.
and FYI the query "$regex" seems to work fine, only the matching doc is updated.
the update section is the issue

script:

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "replace",
        "author": "yourname",
        "changes": [
          {
            "runCommand": {
              "command": {
                "$rawJson": {
                  "findAndModify": "myCollection",
                  "query": {
                    "myField": {
                      "$regex": "thisText"
                    }
                  },
                  "update": {
                    "$set": {
                        "$replaceAll": {
                          "input": "$myField",
                          "find": "thisText",
                          "replacement": "thatText"
                        }
                    }
                  }
                }
              }
            }
          }
        ]
      }
    }
  ]
}

value updated:

"myField": {
                        "$replaceAll": {
                          "input": "$myField",
                          "find": "thisText",
                          "replacement": "thatText"
                        }

[lewishazell]

Hey! To use aggregations like this, you'll want to pass an aggregation pipeline to the update, i.e. put it in an array:

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "replace",
        "author": "yourname",
        "changes": [
          {
            "runCommand": {
              "command": {
                "$rawJson": {
                  "findAndModify": "myCollection",
                  "query": {
                    "myField": {
                      "$regex": "thisText"
                    }
                  },
                  "update": [{
                    "$set": {
                        "$replaceAll": {
                          "input": "$myField",
                          "find": "thisText",
                          "replacement": "thatText"
                        }
                    }
                  }]
                }
              }
            }
          }
        ]
      }
    }
  ]
}

As shown in "Updates with Aggregation Pipeline"