pull from mongo nested array

Question

{
    "partners" : [
        {
            "partnerId" : 5,
            "topicIds" : [
                "59de26f2e4b0f263704769e5"
            ]
        },
        {
            "partnerId" : 45,
            "topicIds" : [
                "alpha",
                "beta"
            ]
        },
        {
            "partnerId" : 12345,
            "topicIds" : [
                "alpha"
            ]
        }
    ]
}

I want to pull certain topicIds from specified partners. So for example I want to pull alpha topic from partnerId = 45 (the entry should remain with topicIds = ["beta"]).

I tried:

db.mypartnercoll.update({}, {$pull:{"partners":{"partnerId":45, "topicIds":{"$in":["alpha"]}}}})

however this removes the entire partnerId = 45 entry. I will have a single partnerId value and multiple topicIds to pull.

Try {$pull:{"partners.topicIds":{"partnerId":45, "topicIds":{"$in":["alpha"]}}}} — Héctor Valls
– Héctor Valls, Commented Nov 6, 2017 at 15:05
WriteResult({ "nMatched" : 0, "nUpserted" : 0, "nModified" : 0, "writeError" : { "code" : 16837, "errmsg" : "cannot use the part (partners of partners.topicIds) to traverse the element ({partners: [ { partnerId: 5.0, topicIds: [ \"59de26f2e4b0f263704769e5\" ] }, { partnerId: 45.0, topicIds: [ \"alpha\", \"beta\" ] }, { partnerId: 12345.0, topicIds: [ \"alpha\" ] } ]})" } }) — sudeepdino008
– sudeepdino008, Commented Nov 6, 2017 at 15:20
Check this: stackoverflow.com/questions/5228210/… Specially, the last answer — Héctor Valls
– Héctor Valls, Commented Nov 6, 2017 at 15:23

frod_junior · Accepted Answer · 2018-06-19 11:24:44Z

0

instead of

db.mypartnercoll.update({}, {$pull:{"partners":{"partnerId":45, "topicIds":{"$in":["alpha"]}}}})

use

db.mypartnercoll.update({"partners.$.partnerId":"yourdesired_partnerId"}, 
{$pull:{"partners":{"partnerId":45, "topicIds":{"$in":["alpha"]}}}})

this is an update query so you can specify in the first {} a certain document or array element to operate on

answered Jun 19, 2018 at 11:24

frod_junior

1152 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

pull from mongo nested array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related