Update field in mongoDB with it's substring

Question

I would like to shorten all long descriptions in my object. I have searched and read many articles but I can't figure out how to do this simple task in mongoDB. What I am trying to achieve would be simple in SQL:

UPDATE AssetDocument SET description = substr(description, 0, 500) WHERE length(description) > 500

Can please someone help me do this in MongoDB?

I have tried this:

db.AssetDocument.updateMany(
{$where: "this.metadata.description.length > 500"},
{$set: { "metadata.description": { $substr: ["metadata.description", 0, 500]}}});

This gives me errmsg: The dollar ($) prefixed field '$substr' in 'metadata.description.$substr' is not valid for storage.

Then I tried this:

db.AssetDocument.find({
  $where: "this.metadata.description.length > 500"
}).forEach(function(e){
  e.metadata.description = {$substr: [e.metadata.description, 0, 500]};
  db.AssetDocument.save(e);
});

But this doesn't work...

Possible duplicate of Update MongoDB field using value of another field — Ashh
– Ashh, Commented Dec 13, 2018 at 11:56

Pubudu Jayawardana · Accepted Answer · 2018-12-13 12:01:03Z

2

This should work:

db.AssetDocument.find({
  $where: "this.description.length > 500"
}).forEach(function(e){
  e.description = e.description.substr(0,500);
  db.AssetDocument.save(e);
});

answered Dec 13, 2018 at 12:01

Pubudu Jayawardana

2,3651 gold badge13 silver badges18 bronze badges

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

Comments

Vipul Pandey · Accepted Answer · 2018-12-13 12:02:22Z

1

you can use like

db.AssetDocument.find({}).forEach(function(e)
{ if(e.description.length<500) 
e.metadata.description=  e.metadata.description.substr(0,500)
 db.AssetDocument.save(e);
});

answered Dec 13, 2018 at 12:02

Vipul Pandey

1,77415 silver badges23 bronze badges

Comments

Bade Lal · Accepted Answer · 2023-09-18 13:54:26Z

0

**This is working**
db.getCollection("AssetDocument").find({
   $where: "this.description.length > 100"
}).forEach(function(e){
   description = e.description.substr(0, 100);
   db.getCollection("AssetDocument").updateOne({_id: e._id}, 
     {"$set": {"description": description}});
});

edited Sep 18, 2023 at 13:54

answered Sep 18, 2023 at 9:23

Bade Lal

1011 silver badge3 bronze badges

Collectives™ on Stack Overflow

Update field in mongoDB with it's substring

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related