Remove embedded MongoDB document using PHP

Question

so I got this embedded structure which looks something like

{
    "_id" : ObjectId("529246fe6803fa2f1c16b7a7"),
    "title" : "presentation 0",
    "description" : "It's an awesome presentation about presentations, dawg!",
    "timestamp" : " 20:32:03",
    "slides" : [ 
        {
            "_id" : ObjectId("529246fe6803fa2f1c16b7a8"),
            "elements" : [ 
                {
                    "_id" : ObjectId("529246fe6803fa2f1c16b7a9"),
                    ...
                },
                ...
       },
       ...
}

Where my root elements are presentations.

Now I want to be able to remove slides and elements using their ids.

I use

$result = $collection->update(
        array('_id' => $presentationId),
        array('$pull' => array('slides' => array('_id' => $slideId))
        ));

to remove slides, which works.

I tried

$result = $collection->update(
        array('_id' => $presentationId),
        array('$pull' => array('slides.elements' => array('_id' => $elementId))
        ));

to remove elements, but that didn't work...

Thanks!

Asya Kamsky · Accepted Answer · 2013-11-25 03:37:11Z

3

To pull a slide from presentation your syntax should be

db.coll.update({_id:presId},{$pull:{"slides._id": slidesId}}

To pull an element from a slide you need to match appropriate slide and use positional operator:

db.coll.update({ "_id": presId, "slides._id":slidesId},
{$pull: {"slides.$.elements":{"_id":elementId"}}})

I would test the second one - some operations on embedded arrays within arrays are not allowed.

edited Nov 25, 2013 at 3:37

answered Nov 24, 2013 at 19:54

Asya Kamsky

42.4k5 gold badges113 silver badges133 bronze badges

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

4 Comments

tpei Over a year ago

thanks! in PHP it's db.coll.update({ _id: presId, "slides._id":slidesId}, {$pull: {"slides.$.elements":{"slides.elements._id":elementId"}}})

Asya Kamsky Over a year ago

Isn't that what I said? :)

tpei Over a year ago

oh sorry, I meant in PHP it's db.coll.update({ _id: presId, "slides._id":slidesId}, {$pull: {"slides.$.elements":{"_id":elementId"}}})

Asya Kamsky Over a year ago

oh doh, of course you're right - I forgot I was already including the first part of the field on the left side... I will edit to fix it.

Collectives™ on Stack Overflow

Remove embedded MongoDB document using PHP

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related