mongoDB : renaming column name in all collection IS NOT UPDATING

Question

example I got

db.collection.update({}, {$rename: {'XUknown': 'XString'}}, false, true);

I tried in nodejs.

await PRODUCT.update(
    {},
    { $rename: { "product_code": "group_code" } }, false, true
  )
    .then((data) => {
      return res.status(200).json(data)
    })
    .catch((error) => {
      res.status(400).json({ error: error, message: 'not possible' })
    })

response I got ..it not updating

{
    "acknowledged": false
}

I think this is a duplicate question. you can find answer from https://stackoverflow.com/a/53447772/7937057 — vencra, Mar 18 '22 at 20:36
but.. its not updating.. its giving response as "acknowledged": false — Habeeb, Mar 19 '22 at 08:50
In this case, you should use: { upsert: false, multi: true}, like so: db.collection.update({}, {$rename: {'XUknown': 'XString'}}, { upsert: false, multi: true}); — nimrod serok, Mar 19 '22 at 09:05
Yes. see playground here: https://mongoplayground.net/p/vzuXd6VzPKx — nimrod serok, Mar 21 '22 at 11:44
Thanks all for the reply.. its issue with db role.. I have assigned the update role to the user.. then it works — Habeeb, Mar 23 '22 at 12:03

score 0 · Answer 1 · answered Apr 08 '23 at 12:53

I had the same issue... ensure you didn't remove the old field from your schema as at the point of running that command. once you run the command and you check your db and notice the changes has been effected, then you can remove the old field from your schema. else it won't work. That is how i solved mine

mongoDB : renaming column name in all collection IS NOT UPDATING

1 Answers1