how to remove an object from embedded array?

Question

Here is the schema of my collection "profile"

{ 
        _id : ObjectId("123"), 
        name : "Tommy", 
        defaultrates : 
        [ 
                {_id : ObjectId("111"), rate : 35.0, raisedOn : "5/2/2009"}, 
                {_id : ObjectId("222"), rate : 55.0, raisedOn : "5/3/2010"}, 
                {_id : ObjectId("333"), rate : 65.0, raisedOn : "5/5/2010"} 
        ] 
}

I want to remove the first index of default rates ({_id : 111, rate : 35.0, raisedOn : "5/2/2009"}).

The result should be:

{ 
        _id : ObjectId("123"), 
        name : "Tommy", 
        defaultrates : 
        [ 
                {_id : ObjectId("222"), rate : 55.0, raisedOn : "5/3/2010"}, 
                {_id : ObjectId("333"), rate : 65.0, raisedOn : "5/5/2010"} 
        ] 
}

I did this in the console:

db.profile.update({'_id: ObjectId("123")},{ $pull: { 'defaultrates':{'_id': "111"}}},{ multi: false })

But sadly, it didn't gave me the desired output.

Please help. What's the proper way of doing this?

Thanks for the correction. But still, it didn't gave the desired output — Bernardo
– Bernardo, Commented Aug 20, 2018 at 5:36

Faraz · Accepted Answer · 2018-08-20 05:33:56Z

1

I think you are mixing and matching quotes and double quotes indiscriminately. Try this:

db.profile.update({
"_id": ObjectId("123")
},
{
    "$pull": {
        "defaultrates": {
            "_id": ObjectId("111")
        }
    }
},
false,
true
);

that false is multi. And true is upsert (if not available, insert one).

edited Aug 20, 2018 at 5:33

answered Aug 20, 2018 at 5:25

Faraz

6,3156 gold badges44 silver badges99 bronze badges

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

6 Comments

Bernardo Over a year ago

Just didt it. The result was: "nMatched" : 1, "nUpserted" : 0, "nModified" : 0

Bernardo Over a year ago

It did not modify the collection. I wonder what I am missing?

Faraz Over a year ago

ok try this one. I edited my answer. I forgot to add object ID inside default rates

Bernardo Over a year ago

Still didn't gave the desired output. Do you have any other ways in order to get the desired output?

Faraz Over a year ago

what is the output you are seeing?

|

Collectives™ on Stack Overflow

how to remove an object from embedded array?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related