How to get specified object inside array MongoDB [duplicate]

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

Akash Srivastava
– Akash Srivastava

2018-04-16 08:41:19 +00:00
Commented Apr 16, 2018 at 8:41 — Akash Srivastava
– Akash Srivastava, Commented Apr 16, 2018 at 8:41

Nicolas · Accepted Answer · 2018-04-16 08:41:50Z

0

You can use this query to do that :

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

answered Apr 16, 2018 at 8:41

Nicolas

4575 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

How to get specified object inside array MongoDB [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related