update embedded documents of arrays of arrays object in mongodb

Question

I have a following document

{
"_id" : ObjectId("5d3fd27b363f482cf67300b5"),
"is_active" : true,
"is_delete" : false,
"email" : "[email protected]",
"phone" : "1234567890",
"agencies" : [ 
    {
        "employees" : [ 
            ObjectId("5d3aeac1ea162253845ac7f8"), 
            ObjectId("5d3aeac1ea162253845ac7f9")
        ],
        "company_role" : [ 
            {
                "employees" : [ 
                    ObjectId("5d3aeac1ea162253845ac7f8"), 
                    ObjectId("5d3aeac1ea162253845ac7f9")
                ],
                "company" : ObjectId("5d3fd27b363f482cf67300b7"),
                "role" : "administrator"
            }, 
            {
                "employees" : [ 
                    ObjectId("5d3aeac1ea162253845ac7f8"), 
                    ObjectId("5d3aeac1ea162253845ac7f9")
                ],
                "company" : ObjectId("5d3fd27b363f482cf67300b8"),
                "role" : "administrator"
            }, 
            {
                "employees" : [ 
                    ObjectId("5d3aeac1ea162253845ac7f8"), 
                    ObjectId("5d3aeac1ea162253845ac7f9")
                ],
                "company" : ObjectId("5d3fd27b363f482cf67300b9"),
                "role" : "administrator"
            }, 
            {
                "employees" : [ 
                    ObjectId("5d3aeac1ea162253845ac7f8"), 
                    ObjectId("5d3aeac1ea162253845ac7f9")
                ],
                "company" : ObjectId("5d3fd27b363f482cf67300ba"),
                "role" : "administrator"
            }
        ],
        "agency" : ObjectId("5d3fd27b363f482cf67300b6")
    }
],
"createdAt" : ISODate("2019-07-30T05:15:39.345Z"),
"updatedAt" : ISODate("2019-07-30T05:15:39.451Z"),
"__v" : 0
}

I want to update the employees array based on the condition of the _id and agencies.agency. if employees exists then not add or else add it

I have tried as follows but it doesn't work for me

modelName.findOneAndUpdate({ ' _id': ObjectId("5d3fd27b363f482cf67300b5"), 'agencies.agency': ObjectId("5d3fd27b363f482cf67300b6") }, { $addToSet: { "agencies.$.employees": ObjectId("5d3aeac1ea162253845ac7f1"), "agencies.$.company_role.employees": ObjectId("5d3aeac1ea162253845ac7f1") } },{new:true})

I am using mongoose to update record

How do you determine which company_role should be modifed ? — mickl
– mickl, Commented Aug 2, 2019 at 6:14

mickl · Accepted Answer · 2019-08-02 06:19:19Z

1

Two useful update operators you can use: $[< identifier > ] and $[] :

modelName.findOneAndUpdate({ '_id': ObjectId("5d3fd27b363f482cf67300b5") },
    { 
        $addToSet: { 
            "agencies.$[agency].employees": ObjectId("5d3aeac1ea162253845ac7f1"),
            "agencies.$[agency].company_role.$[].employees": ObjectId("5d3aeac1ea162253845ac7f1"),
        } 
    },
    {
        arrayFilters: [ { "agency.agency": ObjectId("5d3fd27b363f482cf67300b6") } ]
    })

answered Aug 2, 2019 at 6:19

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

3 Comments

Nitin Over a year ago

I have now tried to add employee in specific company but not able to do it so can you please help me out with addition condition of company id 5d3fd27b363f482cf67300ba

mickl Over a year ago

@Nitin please open another question for clarity

Nitin Over a year ago

it works for me I have added { "com.company": ObjectId("5d3fd27b363f482cf67300b9") }, in arrayFilters and change the condition $addToSet to "agencies.$[agency].company_role.$[com].employees": ObjectId("5d3aeac1ea162253845ac7f1")

Collectives™ on Stack Overflow

update embedded documents of arrays of arrays object in mongodb

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related