search and update within nested array with mongoose

Question

simplified schema of a doc in my Model:

{
    ar1: [
        {
            b: {
                ar2: [{ _id: 1, value: 2 }],
            },
        },
        {
            b: {
                ar2: [{ _id: 2, value: 2 }],
            },
        },
        {
            b: {
                ar2: [{ _id: 1, value: 5 }],
            },
        },
    ];
}

now i want to update all elements of ar2 that have _id equal to 1 so I would obtain:

{
    ar1: [
        {
            b: {
                ar2: [{ _id: 1, value: 3 }],
            },
        },
        {
            b: {
                ar2: [{ _id: 2, value: 2 }],
            },
        },
        {
            b: {
                ar2: [{ _id: 1, value: 3 }],
            },
        },
    ];
}

The following does not work:

Model.updateMany({
    'ar1.b.ar2._id' : 1
},{
    'ar1.$[].b.ar2.$[].value' : 2
});

any suggestions ?

The idea is that i want to be able the elements in the nested array that obey the query and update them.

Cuong Le Ngoc · Accepted Answer · 2020-10-28 11:52:52Z

1

You can use $[] combine with $[<identifier>] to do that:

Model.update(
  {}, 
  { $set: { "ar1.$[].b.ar2.$[el].value": 3 } },  
  { arrayFilters: [ { "el._id": 1 } ] } 
)

answered Oct 28, 2020 at 11:52

Cuong Le Ngoc

12k2 gold badges23 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

search and update within nested array with mongoose

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related