Update with same document field in mongodb

Question

I have a this document.Which has a schema of below:

 rental:{
    total:Number,
    due:Number
}

For example let us assume the document is filled with values like this:

 rental:{
    total:350,
    due:10
}

I want to replace the value of 'total' to 'due'.So i want it to be like this:

 rental:{
    total:350,
    due:350
}

I came accross $set,i did something like this: PS:"User" is the name of the model.(which i havent refrenced here)

User.updateMany({},{$set:{'due':"$total"}},function(err,..}{ 
//do whatever
    }

But this didnt work out.I ran into a CastError. I also came accross '$replaceWith'.But i didnt understand a bit on how to use that in my case.Any help is appriciated.Thank you

Ashh · Accepted Answer · 2020-04-19 16:58:47Z

1

You can use below query

db.collection.update(
  { },
  [{ "$set": { "due": "$total" }}]
)

answered Apr 19, 2020 at 16:58

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Update with same document field in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related