MongoDB: Remove attribute from nested Object Array

Question

I have to remove an attribute from an deep nested object inside an array of objects.
It looks like this:

I want to unset the IndividualAge only for one specific Period Type Past
for one specific Block with the name "HouseKeepingDamageCost", if it exists.
I have to take care, because the other Objects inside Blocks and
other Periods have also an attribute called "IndividualAge", they can stay.
Can someone help me ? I tried it with $elemMatch without success.

Thanks in advance.

Playgorund with my Data & Query: Mongoplayground

add sample data and also the query you tried mongoplayground.net and update the story with the link. — Tushar Gupta - curioustushar
– Tushar Gupta - curioustushar, Commented Mar 24, 2021 at 14:17
@TusharGupta-curioustushar I did add the data & my attempt, please check. — LaFllamme
– LaFllamme, Commented Mar 24, 2021 at 14:39

Tom Slabbaert · Accepted Answer · 2021-03-24 14:49:06Z

2

You want to use arrayfilters to do so:

db.collection.update({},
{
  "$unset": {
    "Blocks.$[block].Periods.$[period].IndividualAge": ""
  }
},
{
  "multi": false,
  arrayFilters: [
    {
      "block.Name": "HouseKeepingDamageCost"
    },
    {
      "period.Type": "Past"
    }
  ]
})

Mongo Playground

answered Mar 24, 2021 at 14:49

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

2 Comments

LaFllamme Over a year ago

this doesn't work for my provided data. mongoplayground.net/p/-Apag7fTtN-

Tom Slabbaert Over a year ago

HousekeepingDamageCost is not with a captial K in the data in your link. regardless if it works for my toy example just adapt it to your code and make sure the values match what you intend.

Collectives™ on Stack Overflow

MongoDB: Remove attribute from nested Object Array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related