MongoDB: how to delete an object from a document in a nested array

Question

My doc is like this

"page_elements" : [
        {
                "type" : "gallery",
                "words" : [
                        "gallery",
                        "photos"
                ]
        },
        {
                "type" : "cart",
                "words" : [
                        "cart",
                        "shop"
                ]
        },
        {
                "type" : "Privacy",
                "words" : [
                        "privacy",
                        "policy",
                        "privacy policy"
                ]
        },
        {
                "type" : "cart",
                "words" : [
                        "cart",
                        "shopping cart",
                        "buy now",
                        "add to cart",
                        "add to basket"
                ]
        }

by mistake, I've updated cart two times. now, i need to remove the first cart in the array and keep the rest of the document.

Here, I need to delete

{
    "type" : "cart",
    "words" : [
        "cart",
        "shop"
    ]
}

I tried this..

db.ds_master_language_words.remove( { "page_elements.type" : "cart" } )

@DanDascalescu Not the same question. He just wants to remove one array element. It's the .remove() method that is wrong here. — Neil Lunn
– Neil Lunn, Commented Feb 27, 2014 at 10:22

Dan Dascalescu · Accepted Answer · 2014-03-07 14:58:23Z

1

You don't want to remove, you want to update. $unset will get rid of the field and you know the position:

db.ds_master_language_words.update(
    { <your_document_id_match > },
    { $unset: { "page_elements.1": ""}}
)

That will set to null in the array, but now that is easy to remove with $pull:

db.ds_master_language_words.update(
    { <your_document_id_match > },
    { $pull: { "page_elements": null }}
)

Also see the documentation for the update method

http://docs.mongodb.org/manual/reference/method/db.collection.update/

edited Mar 7, 2014 at 14:58

Dan Dascalescu

154k66 gold badges336 silver badges422 bronze badges

answered Feb 27, 2014 at 10:20

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

1 Comment

Neil Lunn Over a year ago

@Gireesh my bad, I didn't add the second part of what I did

JohnnyHK · Accepted Answer · 2014-02-27 16:02:47Z

0

You can do this with $pull by giving it a page_elements value that matches the array element to remove:

db.ds_master_language_words.update({}, {
    $pull: {page_elements: {
       "type": "cart",
       "words": ["cart", "shop"]
    }}})

answered Feb 27, 2014 at 16:02

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Collectives™ on Stack Overflow

MongoDB: how to delete an object from a document in a nested array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related