nested array of object remove specific elementin mongoDB

Question

This is my data I want to remove this specific object only:
thanks to advance how to remove the specific object from a nested array element

{ "_id" : ObjectId("5397eb925d2664177b0fc5a6"), "answer" : "Item Question 1 - Answer 1", "isCorrectAnswer" : true }

Input data:

   {
        "_id" : ObjectId("5397e4b75c4c9bf0509709ab"),
        "name" : "Item Name",
        "description" : "Item Description",
        "questions" : [
            {
                "_id" : ObjectId("5397eb925d2664177b0fc5a5"),
                "question" : "Item Question 1",
                "answers" : [
                        {
                            "_id" : ObjectId("5397eb925d2664177b0fc5a6"),
                            "answer" : "Item Question 1 - Answer 1",
                            "isCorrectAnswer" : true
                        },
                        {
                            "_id" : ObjectId("5397eb925d2664177b0fc5a7"),
                            "answer" : "Item Question 1 - Answer 2",
                            "isCorrectAnswer" : false
                        }
                    
                    ]
            },
            {
                "_id" : ObjectId("5397eb925d2664177b0fc5a9"),
                "question" : "Item Question 2",
                "answers" : [
                    {
                        "_id" : ObjectId("5397eb925d2664177b0fc5aa"),
                        "answer" : "Item Question 2 - Answer 1",
                        "isCorrectAnswer" : false
                    },
                    {
                        "_id" : ObjectId("5397eb925d2664177b0fc5ab")
                        "answer" : "Item Question 2 - Answer 2",
                        "isCorrectAnswer" : true
                    }
                ]
            }
        ]
    }

expected output:
   {
        "_id" : ObjectId("5397e4b75c4c9bf0509709ab"),
        "name" : "Item Name",
        "description" : "Item Description",
        "questions" : [
            {
                "_id" : ObjectId("5397eb925d2664177b0fc5a5"),
                "question" : "Item Question 1",
                "answers" : [
                       
                        {
                            "_id" : ObjectId("5397eb925d2664177b0fc5a7"),
                            "answer" : "Item Question 1 - Answer 2",
                            "isCorrectAnswer" : false
                        }
                    ]
            },
            {
                "_id" : ObjectId("5397eb925d2664177b0fc5a9"),
                "question" : "Item Question 2",
                "answers" : [
                    {
                        "_id" : ObjectId("5397eb925d2664177b0fc5aa"),
                        "answer" : "Item Question 2 - Answer 1",
                        "isCorrectAnswer" : false
                    },
                    {
                        "_id" : ObjectId("5397eb925d2664177b0fc5ab")
                        "answer" : "Item Question 2 - Answer 2",
                        "isCorrectAnswer" : true
                    }
                ]
            }
        ]
    }

thanks to advance how to remove the specific object from a nested array element

Dheemanth Bhat · Accepted Answer · 2021-04-01 13:45:16Z

1

Solution in Mongoplayground. Try this:

db.collection.updateOne(
    { "_id": ObjectId("5397e4b75c4c9bf0509709ab") },
    {
        $pull: {
            "questions.$[].answers": {
                "_id": ObjectId("5397eb925d2664177b0fc5a6")
            }
        }
    }
);

Output:

{
    "_id" : ObjectId("5397e4b75c4c9bf0509709ab"),
    "name" : "Item Name",
    "description" : "Item Description",
    "questions" : [
        {
            "_id" : ObjectId("5397eb925d2664177b0fc5a5"),
            "question" : "Item Question 1",
            "answers" : [
                {
                    "_id" : ObjectId("5397eb925d2664177b0fc5a7"),
                    "answer" : "Item Question 1 - Answer 2",
                    "isCorrectAnswer" : false
                }
            ]
        },
        {
            "_id" : ObjectId("5397eb925d2664177b0fc5a9"),
            "question" : "Item Question 2",
            "answers" : [
                {
                    "_id" : ObjectId("5397eb925d2664177b0fc5aa"),
                    "answer" : "Item Question 2 - Answer 1",
                    "isCorrectAnswer" : false
                },
                {
                    "_id" : ObjectId("5397eb925d2664177b0fc5ab"),
                    "answer" : "Item Question 2 - Answer 2",
                    "isCorrectAnswer" : true
                }
            ]
        }
    ]
}

edited Apr 1, 2021 at 13:45

answered Apr 1, 2021 at 12:55

Dheemanth Bhat

4,5022 gold badges30 silver badges43 bronze badges

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

3 Comments

Gowdham GM Over a year ago

its removed those questions array

Dheemanth Bhat Over a year ago

No pal its working for me. Check the updated answer.

Dheemanth Bhat Over a year ago

Check this in Mongoplayground: mongoplayground.net/p/cpf0oSX_29l

Collectives™ on Stack Overflow

nested array of object remove specific elementin mongoDB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related