MongoDB - Update a field in an object of an array with multiple filter conditions

Question

If I have the following document in my database :

{
    "_id" : MainId,
    "subdoc" : [
        {
            "_id" : SubdocId,
            "userid" : "someid",
            "toupdate": false,
        },
        {
            "_id" : SubdocId2,
            "userid" : "someid2",
            "toupdate": false,
        }       
    ],
    "extra" : [
        "extraid1",
        "extraid2"
    ]
}

How can I update the subdocument SubdocId2 where the id (SubdocId2) must match and either SubdocId2's userid is "someid2" OR value "extraid1" exists in "extra"?

The farthest I got is:

db.coll.update({
"subdoc._id":"SubdocId2", {
    $or: ["extra":{$in:["extraid1"]}, "subdoc.userid":"someid2"]
    }
}, {"subdoc.$.toupdate":true})

Maybe I forgot to quote up something, but I get an error (SyntaxError: invalid property id)

ok, so in your update you need to use an ObjectId. "subdoc._id": ObjectId('SubdocId2'). You're using a string — Mauro Petrini
– Mauro Petrini, Commented Jan 18, 2020 at 1:56

whoami - fakeFaceTrueSoul · Accepted Answer · 2020-01-18 05:43:29Z

1

Please try this :

db.coll.update(
    {
        $and: [{ "subdoc._id": SubdocId2 }, {
            $or: [{ "extra": { $in: ["extraid1"] } },
            { "subdoc.userid": "someid2" }]
        }] // subdoc._id && (extra || subdoc.userid)
    }, { $set: { "subdoc.$.toupdate": true } })

In your query there are couple of syntax issues & also if you don't use $set in your update part - it replace the entire document with "subdoc.$.toupdate": true. Of course if you're using mongoose that's different scenario as mongoose will internally does add $set but when executing in shell or any client you need to specify $set. Also if SubdocId2 is ObjectId() you need to convert string to ObjectId() in code before querying database.

answered Jan 18, 2020 at 5:43

whoami - fakeFaceTrueSoul

18.1k6 gold badges35 silver badges51 bronze badges

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

1 Comment

KingFish Over a year ago

Works great! Thanks!

Collectives™ on Stack Overflow

MongoDB - Update a field in an object of an array with multiple filter conditions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related