How to insert field in already existing nested documents in mongodb?

Question

I have the following document structure.

{ 
    "_id" : ObjectId("585a985f67962d91c0f3a1f6"), 
    "Email" : "[email protected]", 
    "PhoneNumber" : "9999999999", 
    "TwoFactorEnabled" : false, 
    "LockoutEndDateUtc" : null, 
    "LockoutEnabled" : true, 
    "AccessFailedCount" : NumberInt(0), 

    "DisplayName" : "Nilesh Guria", 
    "CreatedOn" : ISODate("2016-12-21T14:57:35.379+0000"), 
    "UpdatedOn" : ISODate("2018-09-17T21:32:16.027+0000"),  
    "Wallet" : {
        "Balance" : 1000,
        "UnbilledUsage": 100
    }
}

I want to add a field called "CustomerCredit" with a default value of 0 inside the "Wallet" field in all such documents. How to achieve this ?

Rahul kumar · Accepted Answer · 2018-09-18 13:53:44Z

2

db.collection("collectionName")
  .updateMany({ "Wallet.CustomerCredit": { $exists: false }},
          { $set:{ "Wallet.CustomerCredit": 0 }});

edited Sep 18, 2018 at 13:53

answered Sep 18, 2018 at 13:27

Rahul kumar

441 silver badge9 bronze badges

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

Comments

GraphicalDot · Accepted Answer · 2018-09-18 13:44:21Z

1

From python shell.

db.collection.update_many({"$set": {"Wallet.CustomerCredit": 0}})

You can use update_many since update is now deprecated. From mongoshell

db.collection.updateMany({},{$set: {"Wallet.CustomerCredit": 0}})

edited Sep 18, 2018 at 13:44

answered Sep 18, 2018 at 13:33

GraphicalDot

2,8812 gold badges35 silver badges47 bronze badges

Comments

itepifanio · Accepted Answer · 2018-09-18 13:21:47Z

1

Try something like this:

db.collection.aggregate([
    {
        $addFields{
             "Wallet.CustomerCredit": 0
        }
    }
])

See the docs

answered Sep 18, 2018 at 13:21

itepifanio

5676 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to insert field in already existing nested documents in mongodb?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related