Mongodb rename key in an array of objects

Question

I am trying to update the name of a key inside an object of an array and annoyed due to the inability to make the queries work. I have tried this How rename nested key in array of object in MongoDB? but I still get the same error I was getting earlier

Here is the document:

[
  {
  "accountCreation": [
      {
        "startDateTime": "",
        "endDateTime": "",
        "isDone": "Yes"
      }
    ]
  }
]

Here is my query:

db.collection.update({}, $rename:{
  "accountCreation.$.isDone":"done",
})

All I am trying to do is rename the isDone key to done. Note that this is just one of the many objects that have this key. I am trying to update all the occurences of the isDone key to done inside the accountCreation

Here is the error I am receiving:

fail to run update: write exception: write errors: [cannot use the part (accountCreation of accountCreation.isDone) to traverse the element

ray · Accepted Answer · 2022-03-25 20:58:43Z

3

Actually, the answers to the link you provided already stated that $rename does not work with array.

Nevertheless, you could probably achieve your expected behaviour by using an aggregate with update. You will need to use $objectToArray and $arrayToObject to wrangle the objects if you have other fields.

db.collection.update({},
[
  {
    "$project": {
      accountCreation: {
        "$map": {
          "input": "$accountCreation",
          "as": "ac",
          "in": {
            "$objectToArray": "$$ac"
          }
        }
      }
    }
  },
  {
    "$project": {
      accountCreation: {
        "$map": {
          "input": "$accountCreation",
          "as": "ac",
          "in": {
            "$map": {
              "input": "$$ac",
              "as": "kv",
              "in": {
                "$cond": {
                  "if": {
                    $eq: [
                      "$$kv.k",
                      "isDone"
                    ]
                  },
                  "then": {
                    "k": "done",
                    "v": "$$kv.v"
                  },
                  "else": "$$kv"
                }
              }
            }
          }
        }
      }
    }
  },
  {
    "$project": {
      accountCreation: {
        "$map": {
          "input": "$accountCreation",
          "as": "ac",
          "in": {
            "$arrayToObject": "$$ac"
          }
        }
      }
    }
  }
])

Here is the Mongo playground for your reference.

edited Mar 25, 2022 at 20:58

answered Mar 25, 2022 at 18:54

ray

15.6k12 gold badges97 silver badges104 bronze badges

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

4 Comments

boomchickawawa Over a year ago

thanks for taking a look, i noticed that aggregate is not updating but just giving the edited response as an output. Because when I do a db.collection.find({)) to verify, it shows the isDone key again

ray Over a year ago

@boomchickawawa sorry my bad. updated the answer to change back to use update

boomchickawawa Over a year ago

this is wiping out the other fields that present in the document and returning just the accountCreation array with the updated name when I do a db.collection.find({})

ray Over a year ago

@boomchickawawa you should have stated that your accountCreation object contains other fields at the start. Nevertheless, updated the answer to do it in a more generic way.

R2D2 · Accepted Answer · 2022-03-25 20:20:28Z

This can be done in two steps(mongoDB 4.2+):

Step 1: Add the new field "done"

db.collection.update({
   "accountCreation": {
          $exists: true
      }
   },
   [
   {
     "$addFields": {
       accountCreation: {
         "$map": {
           "input": "$accountCreation",
           "as": "ac",
           "in": {
          $mergeObjects: [
          "$$ac",
          {
            "done": "$$ac.isDone"
          }
         ]
        }
      }
     }
   }
 }
],
{
  multi: true
})

Explained:

Add the field "Done"="$isDone" in all array elements where isDone is found.

playground_step_1

Step 2: Remove the old field "isDone":

  db.collection.update({
   "accountCreation.isDone": {
   "$exists": true
  }
 },
 {
  "$unset": {
    "accountCreation.$[x].isDone": true
 }
},
{
  arrayFilters: [
 {
  "x.isDone": {
    $exists: true
  }
}
],
   multi: true
})

Explained:

Define arrayFilter x and remove the old field "isDone" from all array elements where it is found

playground_step_2

( Afcourse Step 1 need to be executed first!!! )

Collectives™ on Stack Overflow

Mongodb rename key in an array of objects

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related