MongoDB- Add new field from existing array

Question

I am the beginner of the MongoDB

Here I mentioned my database schema

{
"_id" : ObjectId("5e72067973c1241068a13647"),
"client_id" : "1001",
"dependent" : [ 
    {
        "dependent_name" : "asdsa",
        "dependent_id" : "DE100"
    }, 
    {
        "dependent_name" : "fdggd",
        "dependent_id" : "DE101"
    }
  ]
}

I want to add new field based on client_id and dependent_id

Here I mentioned My query but cannot able to get my expected result

 db.collection.update({"client_id" : "1001","dependent.dependent_id":"DE101"}, {"$push": {"reason":"expired"}})

I am Expected Result is

 {
"_id" : ObjectId("5e72067973c1241068a13647"),
"client_id" : "1001",
"dependent" : [ 
    {
        "dependent_name" : "asdsa",
        "dependent_id" : "DE100"
    }, 
    {
        "dependent_name" : "fdggd",
        "dependent_id" : "DE101",
        "reason":"expired"
    }
  ]
}

so anyone help me to solve this

SANJEEV RAVI · Accepted Answer · 2020-03-21 14:28:19Z

1

db.collection.update({"client_id" : "1001","dependent.dependent_id":"DE101"}, 
{$set:
{"dependent.$.reason":"expired"}})

Try this it works for me using $

answered Mar 21, 2020 at 14:28

SANJEEV RAVI

1791 silver badge6 bronze badges

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

Comments

Amit Joshi · Accepted Answer · 2020-03-19 14:03:25Z

0

As i am also new to mongodb, as i tried, i can give you suggestion to update whole document or replace it.
both way i tried, and query is as below.
Update

db.updateColl.update({ 'dependent.dependent_id': 'DE101' },
    {
        $set: {
            "dependent": [
                {
                    "dependent_name": "asdsa",
                    "dependent_id": "DE100"
                },
                {
                    "dependent_name": "fdggd",
                    "dependent_id": "DE101",
                    "reason": "expired"
                }
            ]
        }
    });

Replace

db.updateColl.replaceOne({ 'dependent.dependent_id': 'DE101' }, {
    "dependent": [
        {
            "dependent_name": "asdsa",
            "dependent_id": "DE100"
        },
        {
            "dependent_name": "fdggd",
            "dependent_id": "DE101",
            "reason": "expired"
        }
    ]
})

may be it can help you. if any suggestion regarding it wellcome.

answered Mar 19, 2020 at 14:03

Amit Joshi

4741 gold badge8 silver badges24 bronze badges

2 Comments

arun kumar Over a year ago

you said update full dependent details but I want to inset one field for existing array

Amit Joshi Over a year ago

we can update specific field but it will add at last after dependent node, so output would not matched with yours.

Collectives™ on Stack Overflow

MongoDB- Add new field from existing array

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related