Remove an array if exists inside an array in mongodb

Question

{
"_id" : ObjectId("5cca927ed5494b0"),
"userName": "1234",
"rcReviews": [{
        "userName": "qwert",
        "finalReview": "qtrwyw",
        "dField": [{
                "name": "t2",
                "status": "Not Verified",
                "reviewComment": "asdfag"
            },
            {
                "status": "Not Verified",
                "reviewComment": "asegqrt",
                "name": "t13"
            },
            {
                "name": "c452",
                "status": "Not Verified",
                "reviewComment": "gaeqrtqa "
            },
            {
                "status": "Not Verified",
                "reviewComment": "tyqiqooqa",
                "name": "c13"
            }
        ]
    },
    {
        "userName": "1517",
        "finalReview": "wsywx",
        "dField": [{
                "status": "Not Verified",
                "reviewComment": "aswrrwgqrt",
                "name": "t113"
            },
            {
                "name": "c1516",
                "status": "Not Verified",
                "reviewComment": "gaeqredectqa "
            },
        ]
    }
]}

I want a query which checks dField array key exists in rcReveiws array. If it exists then it has remove the dField array and other contents should be there only dField array should be removed

db.newcopy.updateMany({ "rcReviews": { "$elemMatch": { "$elemMatch": { "dField": { "$exists": true } } } } }, { "$unset": { "rcReviews.$[].$[].dField": "" }} ) I had tried like this. Thank you for responding — Abhishek K V
– Abhishek K V, Commented May 20, 2020 at 10:20

The Cloud Guy · Accepted Answer · 2020-05-20 09:53:04Z

2

You can use the below query. It has been tested with the data provided by you

db.testmongo.update({"rcReviews.dField":{$exists:true}},{$unset:{"rcReviews.$[].dField":""}},{multi:true})

Change the collection name to match yours. The query checks for records that contain the dField attribute in rcReviews array. It updates all the objects inside that array and removes the dField attribute using unset

answered May 20, 2020 at 9:53

The Cloud Guy

1,0011 gold badge9 silver badges20 bronze badges

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

1 Comment

Abhishek K V Over a year ago

Thank you Abhishek Kothari. I have another doubt, if i wanted to remove another key inside the array and that key is type object so if i change name that's enough right no need to change whole query??

Collectives™ on Stack Overflow

Remove an array if exists inside an array in mongodb

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