MongoDB - Update field if new value is greater

Question

How to update a field in a MongoDB document only if the new value is greater then the current value?

Any solution?

db.report.update(
    { _id: 1234 },
    {
      $setIfGreater: {
        A: 10
      }
   })

Answer 1

You can use the $max operator to do this:

db.report.update(
    { _id: 1234 },
    {
      $inc: { A: 5 },
      $set: {
        B: "ABC123",
      }
      $max: {
        C: 10
      }
    })

The $max operator updates the value of the field to a specified value if the specified value is greater than the current value of the field.