How to remove all occurrences of array element in nested array in mongodb

Question

My DataBase Structure is as following , it has only one document and nested array of products which consists ref to product document's id.

{
_id:"6371e078393a5194cc674369"
data: Array
  [0]:{
    image:
    title:
    products: Array
      [0]:product1Id
      [1]:product2Id
      [2]:product3Id
  },
  [1]:{
    image:
    title:
    products: Array
      [0]:product2Id
      [1]:product3Id
      [2]:product4Id
  },
}

My requirement is when I remove product3 from the product document I want to delete its references too. So here i want to delete product3Id from the nested array.

Updated Document would look like:

{
_id:"6371e078393a5194cc674369"
data: Array
  [0]:{
    image:
    title:
    products: Array
      [0]:product1Id
      [1]:product2Id
  },
  [1]:{
    image:
    title:
    products: Array
      [0]:product2Id
      [1]:product4Id
  },
}

My tries:

result = await homeSpecialModel.updateMany(
  {
    _id: "6371e078393a5194cc674369",
  },
  // { $pull: { data: { products: { $eleMatch: new ObjectId(id) } } } } -- 1st try
  // { $pull: { "data.products": new ObjectId(id) } } -- 2nd try
);

Both didn't seem to work !

It is the id of the main document, I have updated the question for more clarity — krishnaacharyaa
– krishnaacharyaa, Commented Nov 16, 2022 at 4:47

rickhg12hs · Accepted Answer · 2022-11-16 05:03:09Z

2

Here's one way to do it using "arrayFilters".

db.collection.update({
  _id: "6371e078393a5194cc674369"
},
{
  "$pull": {
    "data.$[elem].products": ObjectId("6371e078393a5194cc67436b")
  }
},
{
  "multi": true,
  "arrayFilters": [
    {
      "elem.products": ObjectId("6371e078393a5194cc67436b")
    }
  ]
})

Try it on mongoplayground.net.

answered Nov 16, 2022 at 5:03

rickhg12hs

12k6 gold badges31 silver badges50 bronze badges

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

1 Comment

Ismail Muhammad Over a year ago

can you help me to solve this stackoverflow.com/questions/74455783/…

Collectives™ on Stack Overflow

How to remove all occurrences of array element in nested array in mongodb

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related