How to get specified object inside array MongoDB

Question

I working on NodeJS and MongoDB and I have database JSON like this

{
   _id: "123"
   classroom: [
    {
      classId: "2046"
      className: "10b"
    },
    {
      classId: "2079"
      className: "12b"
    }   
  ]
},

{
   _id: "456"
   classroom: [
    {
      classId: "2069"
      className: "36b"
    },
    {
      classId: "2011"
      className: "36c"
    }   
  ]
}

I want to delete classroom on

_id: "123" and have classId: "2046"

,so after delete process, I will have JSON like this

   {
       _id: "123"
       classroom: [
        {
          classId: "2079"
          className: "12b"
        }   
      ]
    },

    {
       _id: "456"
       classroom: [
        {
          classId: "2069"
          className: "36b"
        },
        {
          classId: "2011"
          className: "36c"
        }   
      ]
    }

So please help me to do that, any advices are very welcome thank you

I think this is the similar question [stackoverflow link](https://stackoverflow.com/questions/16959099/how-to-remove-array-element-in-mongodb) — Akash Srivastava, Apr 16 '18 at 08:41

score 0 · Accepted Answer · answered Apr 16 '18 at 08:41

0

You can use this query to do that :

db.collection.update({
    _id: '123'
}, {
    $pull: {
        classroom: {
            classId: '2046'
        }
    }
});

answered Apr 16 '18 at 08:41

Nicolas

457
5
15

thank you very much – fahmika Apr 18 '18 at 14:16

How to get specified object inside array MongoDB

1 Answers1