remove element from embedded document in mongodb

Question

I am using mongodb library for codeigniter.i want to delete element from embedded document. my collection is as follows-

{
"_id" : ObjectId("56503a272f170d30298b45ad"),
"gm_creation_time" : "2015-11-21 09:32:23",
"gm_favourites" : [
    {
        "gm_user_id" : "55f90ccf2f170d79048b4570",
        "gm_id" : "56503a272f170d30298b45ad",
        "date" : "2015-11-21 09:32:40"
    }
],
"gm_members" : [
    "560391de2f170d1e108b4574",
    "55f90ccf2f170d79048b4570"
],
"gm_name" : "Sunny@ccs",
"gm_owner" : "55f90ccf2f170d79048b4570",
"gm_photo" : null,
"gm_posts" : [ ],
"gm_type" : "1",
"gm_updation_time" : "2015-11-21 09:32:40"
}

How can I delete from favorites according to gm_user_id. I am new to codeigniter+mongodb. please help

Possible duplicate of How do I remove a field completely from Mongo? — Luboš Turek
– Luboš Turek, Commented Nov 21, 2015 at 10:32

chridam · Accepted Answer · 2015-11-21 11:12:05Z

Use the $pull array modifier operator to remove all instances of a value or values that match a specified condition from an existing array.

The following mongo operation updates all documents in the collection to remove the object with "gm_user_id" property that has a value of "55f90ccf2f170d79048b4570" from the array gm_favourites:

db.collection.update(
    { },
    { 
        "$pull": { 
            "gm_favourites": { 
                "gm_user_id": "55f90ccf2f170d79048b4570" 
            }
        } 
    },
    { "multi": true }
);

This will translate to PHP as follows:

$connection = new Mongo();
$db = $connection->selectDB('dbname');
$collection = $db->selectCollection('collection_name');

$filter = array();
$remove_document = array(
    '$pull' => array(
        'gm_favourites' =>  array(
            'gm_user_id' =>  '55f90ccf2f170d79048b4570',
        ) 
    ) 
);
$options['multiple'] = true;

$collection->update($filter, $remove_document, $options);

Sarath Nair · Accepted Answer · 2015-11-21 10:53:57Z

1

If you want to remove the embedded document based on gm_user_id use the following command. (Assuming the collection name is favorites):

db.test.update( {} , {$pull:{'gm_favourites':{'gm_user_id' : '55f90ccf2f170d79048b4570'}}})

The above command will remove the matching embedded document.

answered Nov 21, 2015 at 10:53

Sarath Nair

2,8682 gold badges24 silver badges36 bronze badges

1 Comment

sneha Over a year ago

how can I use this in codeigniter, i have tried like this- $this->mongo_db->pull('gm_favourites',array('gm_id' => $groupId, 'gm_user_id' => $userId))->update('group_master'); but it is not working

Collectives™ on Stack Overflow

remove element from embedded document in mongodb

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related