How to delete an object in nested array of objects in MongoDB with node js

Question

I'm still a beginner in node express js and mongoDB. Right now, I'm trying to Delete an object in nested array of objects.

Array of Objects:

[{
  _id: new ObjectId("63d89f8823981819cf61816e"),
  iqc: [
    {
      partname: 'jio',
      vendorname: 'jio',
      partcode: '1234',
      grndate: '2023-01-10',
      project: 'jio',
      lotqty: '200',
      failurerate: '15%',
      issuedetails: 'damaged',
      status: 'pending',
      _id: new ObjectId("63d89f8823981819cf61816f")
    },
    {
      partname: 'sky',
      vendorname: 'sky',
      partcode: '5678',
      grndate: '2023-01-04',
      project: 'sky',
      lotqty: '300',
      failurerate: '20%',
      issuedetails: 'damaged',
      status: 'pending',
      _id: new ObjectId("63d89f8823981819cf618170")
    }
  ],
  __v: 0
}]

I want to delete the object in iqc which has the _id: new ObjectId("63d89f8823981819cf618170").

So i tried this code for deleting in node js. It didnt work.It throws an error data.iqc.findByIdandDelete is not a function

app.delete('/delete/:id/:secondid', async (req, res) => {
    const data = await IQC.findById(req.params.id);

if(data )
    {
        await data.iqc.findByIdandDelete(req.params.secondid)
        return res.json("Deleted  Successfully")
    }

});

Here IQC is the db collection and secondid is the id of the nested object id which I wanted to delete _id: new ObjectId("63d89f8823981819cf618170").

Thanks in Advance.

J.F. · Accepted Answer · 2023-01-31 12:24:16Z

1

You don't need to delete but update using $pull because you are updating the array (removing the object).

So you can try something like this

yourModel.update({
  "iqc._id": req.params.id
},
{
  "$pull": {
    "iqc": {
      "_id": req.params.id
    }
  }
})

Example here

answered Jan 31, 2023 at 12:24

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Comments

Tyler2P · Accepted Answer · 2023-02-10 15:47:19Z

0

I figured it out. This should be working in NodeJS. No problemo.

app.delete('/delete/:id/:secondid', async (req, res) => {
  await IQC.findOneAndUpdate(
    {
      _id: req.params.id
    }, {
      $pull: {
        iqc: {
          _id: req.params.secondid
        }
      }
    }
  )
}

edited Feb 10, 2023 at 15:47

Tyler2P

2,37030 gold badges26 silver badges34 bronze badges

answered Feb 8, 2023 at 10:30

Richard David

114 bronze badges

Collectives™ on Stack Overflow

How to delete an object in nested array of objects in MongoDB with node js

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related