Mongoose add/remove items from nested array

Question

I have a document that has a nested array that I need to add/remove items from. Normally you query a nested object by id but in this case a dynamic object _id wont work and I need to update by the nested profile id.

Document

{
    title: 'Title',
    members: [
      { 
          profile: { id: '123', name: 'Foo' },
          items: ['id1', 'id2', 'id3']
      }
    ]
}

Query

My thinking is I need some sort of $elemMatch & $pushAll combo but cant seem to get it working. For removing items from the array I would swap push for pull

await this.repo.findByIdAndUpdate(id, {
    members: {
        $elemMatch: { 'profile.id': '123' },
        $pushAll: {
            items: ['xxx', 'yyy'],
        },
    },
})

R2D2 · Accepted Answer · 2022-02-06 00:09:37Z

0

You need to use arrayFilters & $push with $each since $pushAll has been deprecated

db.collection.update({},
{
 $push: {
   "members.$[x].items": {
     $each: [
       "xxx",
       "yyy"
     ]
   }
 }
},
 {
  arrayFilters: [
    {
     "x.profile.id": "123"
    }
  ]
})

playground

answered Feb 6, 2022 at 0:09

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Mongoose add/remove items from nested array

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