MongoDB - Add elements to sub array that meets the filter condition

Question

Here is an example : example

I am trying to add 'X' and 'Y' only to the subcategory arrays that contains EDUCATION key. What is happening here is that it adds 'X' and 'Y' to all subcategory if at least on of them contains the EDUCATION key.

your playground link is missing

Charchit Kapoor
– Charchit Kapoor

2022-06-17 10:11:37 +00:00
Commented Jun 17, 2022 at 10:11 — Charchit Kapoor
– Charchit Kapoor, Commented Jun 17, 2022 at 10:11

Charchit Kapoor · Accepted Answer · 2022-06-17 12:17:12Z

1

You need to use arrayFilters, to match specific element in an array.

db.collection.update({},
{
  "$push": {
    "data.category.$[elem].subcategory": {
      "$each": [
        "X",
        "Y"
      ]
    }
  }
},
{
  multi: true,
  arrayFilters: [
    {
      "elem.subcategory": "EDUCATION"
    }
  ]
})

Check this link

edited Jun 17, 2022 at 12:17

answered Jun 17, 2022 at 10:20

Charchit Kapoor

9,3242 gold badges11 silver badges26 bronze badges

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

4 Comments

Fahd Lihidheb Over a year ago

Doesnt work sir

Charchit Kapoor Over a year ago

It only adds to the docs, whose subcategory contains EDUCATION isn't it expected? Can you paste the expected output in the question

Fahd Lihidheb Over a year ago

this only adds to the first subcategory list. if you add $[] it will fail again

Fahd Lihidheb Over a year ago

Thnx sir ;) ---

Collectives™ on Stack Overflow

MongoDB - Add elements to sub array that meets the filter condition

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related