mongodb updateMany nested array

Viewed 20

I've got the following object and want to update ArrayOne.ArrayTwo.DocumentTypeID from that ID to a different ID:

{
    "_id" : NUUID("97cd06e9-3449-45db-be69-fce30ee1f9b8"),
    "ArrayOne" : [ 
        {
            "ID" : NUUID("70d99c86-414c-401a-9cc9-91661806c10f"),
                     "ArrayTwo" : [ 
                {
                    "EvidenceID" : NUUID("0799492a-b312-4832-a830-ce4ff841d5fd"),
                    "DocumentTypeID" : NUUID("fa67acee-2d56-4174-954f-f1bdc892add0"),
                    "FileID" : NUUID("e5f433c6-8c7f-008d-6d2a-12a908f91690"),
                    "FileName" : "testqwerty.pdf",
                    "AdjudicationStatus" : 0,
                    "SubmitDateTime" : ISODate("2022-09-12T14:14:15.060Z")
                }
            ],
            "Propertyone" : null,
            "Propertytwo" : null,
            "Propertythree" : 0
        }
    ]
}

Trying to use:

db.getCollection('Collection').updateMany
(
{"ArrayOne.ArrayTwo.DocumentTypeID" : NUUID("FA67ACEE-2D56-4174-954F-F1BDC892ADD0")},
{$set : {"ArrayOne.ArrayTwo.DocumentTypeID" : NUUID("090F89EF-3AAE-45F2-853F-5B8C7B8AC0CA")}}
)

I do not want to specify the element as 'ArrayOne' can have up to 10 elements and so can "ArrayTwo" the DocumentTypeID however has a unique GUID.

Can someone please let me know how I can do this ? Thanks

0 Answers
Related