Update multiple embedded documents in multiple documents in MongoDB

Question

I am trying to update multiple embedded documents in multiple documents in MongoDB using mongoose in nodejs.

An example of the document is shown below.

As you can see, in a 'exampleDocument' there is an embedded document: 'embededDoc'.

let exampleDocument =  
    {   
        _id: '1aa',
        player_id: '9pp',
        docUpdated: false',
        embededDoc:
        [ 
            { 
            _id: '3eb',
            embededDocUpdated: false,
            timeDocWasSaved: '2019-04-30T08:45:50.349Z' 
            } 
        ],
    }

How can I update multiple embedded 'embededDoc' documents in multiple 'exampleDocument' documents.

With the help of this answer I know how to update multiple documents with a single command like you can see below:

db.exampleDocument.update(
   { _id: { $in: ['1aa', '2bb', '3cc'] } },
   { $set: { docUpdated : yes } }
)

What if I wanted to update several embeded documents(embededDoc) by their ids?

For example assuming we have three 'exampleDocument' documents with the ids: '1aa', '2bb', '3cc'. And each of these documents has five embeded documents and I wanted to update some of the embeded documents by their ids... is it possible to do it with one command or will I have to do it document by document?

If possible I would really appreciate a code example with the answer, thank you.

Vikash_Singh · Accepted Answer · 2019-04-30 13:38:45Z

1

You have to use filtered positional update operater $[elem], Try below solution, i have tested it with some sample documents given below:

Solution:

    db.test.update({
        _id: { 
            $in: ['1aa', '1bb', '1cc'] 
        }
    }, {
        $set: {
            "embededDoc.$[elem].embededDocUpdated": true,
            "docUpdated" : "yes"
        }
    }, { arrayFilters: [{"elem._id": {$in: ['3ed',"3eg","3eb","3eh"]}}], multi: true})

i have tested above query with below sample Documents and its working fine as you want:

    [{
        "_id" : "1cc",
        "player_id" : "9pp",
        "docUpdated" : false,
        "embededDoc" : [
            {
                "_id" : "3ed",
                "embededDocUpdated" : false,
                "timeDocWasSaved" : "2019-04-30T08:45:50.349Z"
            },
            {
                "_id" : "3eh",
                "embededDocUpdated" : false,
                "timeDocWasSaved" : "2019-04-30T08:45:50.349Z"
            }
        ]
    },
    {
        "_id" : "1bb",
        "player_id" : "9pp",
        "docUpdated" : false,
        "embededDoc" : [
            {
                "_id" : "3ec",
                "embededDocUpdated" : false,
                "timeDocWasSaved" : "2019-04-30T08:45:50.349Z"
            },
            {
                "_id" : "3eg",
                "embededDocUpdated" : false,
                "timeDocWasSaved" : "2019-04-30T08:45:50.349Z",
            }
        ]
    },
    {
        "_id" : "1aa",
        "player_id" : "9pp",
        "docUpdated" : false,
        "embededDoc" : [
            {
                "_id" : "3eb",
                "embededDocUpdated" : false,
                "timeDocWasSaved" : "2019-04-30T08:45:50.349Z",
            },
            {
                "_id" : "3ef",
                "embededDocUpdated" : false,
                "timeDocWasSaved" : "2019-04-30T08:45:50.349Z"
            }
        ]
    }]

answered Apr 30, 2019 at 13:38

Vikash_Singh

1,8962 gold badges16 silver badges27 bronze badges

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

2 Comments

YulePale Over a year ago

Just tested it in the mongoDB terminal... It works like a charm... Thank you very much.

YulePale Over a year ago

Hey :) kindly check out this question. Thank you.

Ashwanth Madhav · Accepted Answer · 2019-04-30 13:04:10Z

1

Try with this

db.collection.update(
{ "embededDoc._id": "3eb" },
{ $set: { "embededDoc.$.embededDocUpdated" :true  } }
)

edited Apr 30, 2019 at 13:04

answered Apr 30, 2019 at 11:58

Ashwanth Madhav

1,2341 gold badge12 silver badges23 bronze badges

7 Comments

YulePale Over a year ago

Thank you but this does not answer the question. I am trying to updated multiple nested documents found in multiple documents.

Ashwanth Madhav Over a year ago

Can you provide a correct document for this ? Are you trying to update embededDocUpdated for all documents in the where condition ?

YulePale Over a year ago

Yes I am trying to update embeddedDocUpdated but not all of them I am trying to update them by their ids...

Ashwanth Madhav Over a year ago

Updated the answer.

Ashwanth Madhav Over a year ago

If you eant to updame multiple, you can use updateMany. $ is array update operators https://docs.mongodb.com/manual/reference/operator/update/positional/

|

Collectives™ on Stack Overflow

Update multiple embedded documents in multiple documents in MongoDB

2 Answers 2

2 Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related