mongoDB : renaming column name in all collection IS NOT UPDATING

Asked Mar 18 '22 at 16:09

Active Mar 18 '22 at 16:09

Viewed 43 times

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
}

asked Mar 18 '22 at 16:09

Habeeb

1

What's the purpose of `false, true`? – rickhg12hs Mar 18 '22 at 16:37
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
false, true for upsert, multi – Habeeb Mar 19 '22 at 08:51
1

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
is it applicable to mongodb version 5? – Habeeb Mar 21 '22 at 11:15
1

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

mongoDB : renaming column name in all collection IS NOT UPDATING

0 Answers0