Conditionally update nested object value in mongoDB

Question

I have following nested object to update after some conditions.based on the condition finally iwant to update promotional or transactional value

{
    "_id" : "XX1",   
    "credit" : {
        "sms" : {
            "credit" : {
                "promotional" : 0,
                "transactional" : 1231
            }
        },
        "viber" : {
            "credit" : {
                "promotional" : 10,
                "transactional" : 50
            }
        },
        "whatsapp" : {
            "credit" : {
                "promotional" : 30,
                "transactional" : 40
            },            
        }
    },
}

conditions will based on the passing variable values

 accountId = "XX1",
 channel = "sms",
 messageType = "promotional",
 credit = 150

these are the conditions should check befor update

_id should match with accountId
if channel='sms',it should select credit.sms
if messageType = "promotional" then check promotional value is greater than to credit or not
if it is greater than to credit value (credit.sms.credt.promotional) should update with : (credit.sms.credt.promotional)-credit

what is your MongoDB version ?

whoami - fakeFaceTrueSoul
– whoami - fakeFaceTrueSoul

2020-04-17 19:44:27 +00:00
Commented Apr 17, 2020 at 19:44 — whoami - fakeFaceTrueSoul
– whoami - fakeFaceTrueSoul, Commented Apr 17, 2020 at 19:44

Cuong Le Ngoc · Accepted Answer · 2020-04-18 03:04:55Z

2

You can use Computed property name and $inc operator to do it. Something like:

YourModel.findOneAndUpdate(
  { _id: accountId, [`credit.${channel}.credit.${messageType}`]: { $gte: credit } },
  { $inc: { [`credit.${channel}.credit.${messageType}`]: -credit} }
)

answered Apr 18, 2020 at 3:04

Cuong Le Ngoc

12k2 gold badges23 silver badges43 bronze badges

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

1 Comment

Yasiru Attanayake Over a year ago

thanks it works for greater than values.also if it is less than to credit,i want to assign current credit.${channel}.credit.${messageType} into variable and update document record into 0

Collectives™ on Stack Overflow

Conditionally update nested object value in mongoDB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related