Mongoose $inc with maximum value

Question

So I'm currently trying to perform this operation

return this.model.findByIdAndUpdate(id, { $push: { certifiedBy: certifier } }, { $inc: {score: 1}}, { new: true })

The issue here is that score will grow without limit, I would like to prevent this and make it so when this is happening it cannot increment if score <= 5 but still add certifier into my certifiedBy array.

Can it be done with mongoose directly or do I have to get the object first check if it over 5 and call a different query in that case ?

Thanks

You can limit your field using max in schema... see here https://stackoverflow.com/questions/34892143/mongoose-behaviour-around-min-and-max-with-number — Ashh, Jun 12 '18 at 12:28
answer posted below, please approve answer if your like my efforts — Ratan Uday Kumar, Jun 12 '18 at 12:34
I commented your answer, can you make sure it's gonna work in the situation I said ? — girard_s, Jun 12 '18 at 12:39

score 0 · Accepted Answer · answered Jun 12 '18 at 12:32

0

You can't change the $inc behaviour but you can do a checkpoint to stop it before 5

return this.model.findOneAndUpdate({
    _id: id,
    score: {
        $lte: 5
    }
}, {
        $push: { certifiedBy: certifier },
        $inc: { score: 1 }
    },
    {
        new: true
    })

answered Jun 12 '18 at 12:32

Ratan Uday Kumar

5,738
6
35
54

If i'm understanding well, this will not push in `certifiedBy`, what I want is `certifiedBy` to still be updated (add the new certifier inside) but not increment score. I might be wrong when it comes to the understanding of your code – girard_s Jun 12 '18 at 12:35
in this case it is not possible – Ratan Uday Kumar Jun 12 '18 at 12:39
you have to update certificate separately and increment functionality seperately – Ratan Uday Kumar Jun 12 '18 at 12:40

Mongoose $inc with maximum value

1 Answers1