MongoDB, remove object from array

Question

Doc:

{
   _id: 5150a1199fac0e6910000002,
   name: 'some name',
   items: [{
      id: 23,
      name: 'item name 23'
   },{
      id: 24,
      name: 'item name 24'
   }]
}

Is there a way to pull a specific object from an array? I.E. how do I pull the entire item object with id 23 from the items array.

I have tried:

db.mycollection.update({'_id': ObjectId("5150a1199fac0e6910000002")}, {$pull: {id: 23}});

However I am pretty sure that I am not using 'pull' correctly. From what I understand pull will pull a field from an array but not an object.

Any ideas how to pull the entire object out of the array.

As a bonus I am trying to do this in mongoose/nodejs, as well not sure if this type of thing is in the mongoose API but I could not find it.

Have you tried this? stackoverflow.com/questions/9048424/… — Myrne Stol
– Myrne Stol, Commented Mar 26, 2013 at 16:05

Kaspar Lee · Accepted Answer · 2021-02-27 22:40:03Z

216

try..

db.mycollection.update(
    { '_id': ObjectId("5150a1199fac0e6910000002") }, 
    { $pull: { items: { id: 23 } } },
    false, // Upsert
    true, // Multi
);

edited Feb 27, 2021 at 22:40

Kaspar Lee

5,6465 gold badges33 silver badges55 bronze badges

answered Mar 26, 2013 at 16:09

sambomartin

6,8237 gold badges43 silver badges64 bronze badges

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

3 Comments

lostintranslation Over a year ago

yup, my syntax was wrong. Thanks! Also tried without the upset and multi options and that worked as well.

Nicolas Del Valle Over a year ago

What are those boolean values?

Lukas Liesis Over a year ago

@NicolasDelValle if I remember correctly, these were options upsert and multi. For current syntax & documentation check this link: docs.mongodb.com/manual/reference/method/db.collection.update

Kaspar Lee · Accepted Answer · 2021-02-27 22:41:05Z

13

I have a document like

I have to delete address from address array

After searching lots on internet I found the solution

Customer.findOneAndUpdate(query, { $pull: {address: addressId} }, (err, data) => {
    if (err) {
        return res.status(500).json({ error: 'error in deleting address' });
    }

    res.json(data);
});

edited Feb 27, 2021 at 22:41

Kaspar Lee

5,6465 gold badges33 silver badges55 bronze badges

answered Jul 23, 2015 at 10:23

Deepak Sisodiya

8489 silver badges11 bronze badges

2 Comments

Ever Think Over a year ago

How to do this in MongoDB CLI ?

Vikas Chauhan Over a year ago

I think this is nodejs (express) solution not the MongoDB query solution

turivishal · Accepted Answer · 2021-04-28 05:01:00Z

8

my database:

{
  "_id" : ObjectId("5806056dce046557874d3ab18"),
  "data" : [ 
    { "id" : 1 }, 
    { "id" : 2 }, 
    { "id" : 3 }
  ]
}

my query:

db.getCollection('play_table').update({},{$pull:{"data":{"id":3}}},{multi:true}

output:

{
  "_id" : ObjectId("5806056dce046557874d3ab18"),
  "data" : [ 
    { "id" : 1 }, 
    { "id" : 2 }
  ]
}

edited Apr 28, 2021 at 5:01

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

answered Oct 18, 2016 at 11:43

Viral Patel

95110 silver badges11 bronze badges

Comments

Shubham Verma · Accepted Answer · 2018-03-23 06:01:41Z

6

You can try it also:

db.getCollection('docs').update({ },{'$pull':{ 'items':{'id': 3 }}},{multi:true})

answered Mar 23, 2018 at 6:01

Shubham Verma

10.2k8 gold badges70 silver badges87 bronze badges

Comments

Kaspar Lee · Accepted Answer · 2021-02-27 22:41:51Z

6

For a single record in array:

db.getCollection('documents').update(
    { },
    {'$pull':{ 'items':{'mobile': 1234567890 }}},
    {new:true}
);

For a multiple records with same mobile number in array:

db.getCollection('documents').update(
    { },
    {
        $pull: {
            items: { mobile: 1234567890 }
        }
    },
    { new:true, multi:true }
)

edited Feb 27, 2021 at 22:41

Kaspar Lee

5,6465 gold badges33 silver badges55 bronze badges

answered May 1, 2020 at 9:25

Chandrakesha Rao

1833 silver badges1 bronze badge

Comments

KARTHIKEYAN.A · Accepted Answer · 2018-08-20 10:07:12Z

1

Use $pull to remove the data

return this.mobiledashboardModel
.update({"_id": args.dashboardId}, { $pull: {"viewData": { "_id": widgetId}}})
.exec()
.then(dashboardDoc => {
     return {
        result: dashboardDoc
     }
});

edited Aug 20, 2018 at 10:07

answered Feb 3, 2017 at 12:14

KARTHIKEYAN.A

20.5k11 gold badges139 silver badges151 bronze badges

Comments

JON · Accepted Answer · 2021-01-11 11:02:04Z

0

Kishore Diyyana:

If you want to remove all elements including the key of the element attributes list.

Here is the example of mongoDB unset operator:

db.UM_PREAUTH_CASE.update(
{ 'Id' : 123}, { $unset: { dataElements: ""} } )

JSON Look like this:

{ "Id":123,"dataElements" : [ { "createdBy" : "Kishore Babu Diyyana", "createdByUserId" : 2020 }, { "createdBy" : "Diyyana Kishore", "createdByUserId" : 2021 } ] }

edited Jan 11, 2021 at 11:02

JON

1,0232 gold badges12 silver badges28 bronze badges

answered Oct 27, 2020 at 16:05

Kishore Babu Diyyana

93 bronze badges

Comments

ANKIT MISHRA · Accepted Answer · 2023-03-23 09:58:56Z

Very simple way to do this:-

Sample data that I used is:-
{
            "_id": "6419606109433f61b50dfaa4",
            "category": "SUV",
            "vehicles": [
                {
                    "id": "18d527aa-948e-40bc-9ce1-c54dc04a6350"
                    "name": "Honda City 4th Generation",
                    "average": "23.26 kmpl",
                    "cc": "1197 cc",
                    "seat": "5 Seater",
                },
{
                    "id": "18d527aa-948e-40bc-9ce1-c54dc04a6349"
                    "name": "Honda City 4th Generation",
                    "average": "23.26 kmpl",
                    "cc": "1197 cc",
                    "seat": "5 Seater",
                },
}

exports.delete_vehicle = async (req, res, next) => {
  const { id, vuuid } = req.params;
  const vehicle = await VehicleCategory.find({ _id: id });
  try{
    for(let i = 0; i < vehicle[0].vehicles.length; i++){
      if(vehicle[0].vehicles[i].id === vuuid){
        await VehicleCategory.findByIdAndUpdate(
          {_id:id},
          { $pull: { vehicles: { id: vuuid } } },
          { new: true }
        );
        res.status(200).json({
          message: "Vehicle deleted successfully."
        });
      }else{
        res.status(404).json({
          message: "The given id is not found."
        });
      }
    }
  }catch (err) {
    res.status(500).json({
      error: err
    });
  }
  

};

router.put("/deleteVehicle/:id/:vuuid", userController.delete_vehicle);

Collectives™ on Stack Overflow

MongoDB, remove object from array

8 Answers 8

3 Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

3 Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related