Update nested object multiple fields

Question

I am trying to figure out how to update the fields nested in a child object within a document in mongodb, there doesnt seem to be a way to do it. Here's what I have.

This is an object. I want to update the fields description, amount and approved attributes

{
    "_id": "...",
    "transaction": {
        "amount": 1,
        "description": "Birthday Money",
        "approved": false,
        "child_id": "...",
        "user_id": "...",
        "_id": "..."
    }
}

I've tried pretty much everything using the $set, but most things will overwrite all fields in the transaction object except for the updated ones or set onto the main document (outside transaction).

I have an object data = { amount: 11, description: "new desc", approved: true }

how can I use the $set update object to update these fields and not destroying the other nested fields

Salvador Dali · Accepted Answer · 2015-04-02 20:39:49Z

1

Use dot notation:

db.test.update(
  {_id: '...'},
  {$set: {
    'transaction.amount' : 44,
    'transaction.approved' : true,
    'transaction.description': 'new stuff'
  }}
)

Do not forget multi if you want update many things.

answered Apr 2, 2015 at 20:39

Salvador Dali

224k151 gold badges726 silver badges766 bronze badges

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

2 Comments

kschieck Over a year ago

Is there no other way of doing it? I may include some or all of those attributes.

Salvador Dali Over a year ago

@kschieck What is wrong with this way? You can include only one attribute, or as many as you need. Also you can update fields not in transaction field as well.

Collectives™ on Stack Overflow

Update nested object multiple fields

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related