How to write Mongo db changeset to remove child node

Question

I have a List of Documents like below which I got it from Mongodb

{
"_id":"some_random_id"
"name": "report1"
"reportDef":
    {
    "reportParameters":
        ["a",
        "b",
        "c",
        "d",
        "e"
        ]
    }
    
"type": "CUSTOM"
"reportId": "desiredReport"
}


{
"_id":"some_random_id"
"name": "report1"
"reportDef":
    {
    "reportParameters":
        ["e",
        "f",
        "b",
        "y",
        "z"
        ]
    }
    
"type": "CUSTOM"
"reportId": "desiredReport"
}

and I need to remove "b" from the reportParameters if this condition satisfies i.e., if type="CUSTOM" and reportId="desiredReport"

means final json document should be like below

{
"_id":"some_random_id"
"name": "report1"
"reportDef":
    {
    "reportParameters":
        ["a",
        "c",
        "d",
        "e"
        ]
    }
    
"type": "CUSTOM"
"reportId": "desiredReport"
}

{
"_id":"some_random_id"
"name": "report1"
"reportDef":
    {
    "reportParameters":
        ["e",
        "f",
        "y",
        "z"
        ]
    }
    
"type": "CUSTOM"
"reportId": "desiredReport"
}

How to add changeset to achieve this?

oneWalker · Accepted Answer · 2023-04-27 14:16:34Z

0

db.collection.updateMany(
  {
    "type": "CUSTOM",
    "reportId": "desiredReport"
  },
  {
    "$pull": {
      "reportDef.reportParameters": "b"
    }
  }
);

answered Apr 27, 2023 at 14:16

oneWalker

548 bronze badges

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

1 Comment

Mark Rotteveel Over a year ago

Your answer only contains code. I recommend that you don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes.

Collectives™ on Stack Overflow

How to write Mongo db changeset to remove child node

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related