Delete id within nested array

Question

So far I can only manage to delete the first id (in this case the id with "12345").

Im trying to delete the row with id 2 within books-array

 Libary Table: 

   {
    "_id": {
        "$oid": "12345"
    },
    "libaryName": "A random libary",
    "Books": [       
        {
            "_id": {
                "$oid": "1"
            }
            "bookTitle": "Example",
            "TotalPages": "500"                 
        },
        {
            "_id": {
                "$oid": "2"
            }
            "bookTitle": "Delete Me",
            "TotalPages": "400"                 
        }
    ]
}

My delete code:

router.delete('/:id', (req, res) => {
  Libary.remove({ _id: req.params.id })
    .then(() => {
      //redirect
    });
});

How can I reach and delete the book row where the id is 2?

Rohail Najam · Accepted Answer · 2018-03-17 14:10:33Z

2

You need to use $pull opertator

router.delete('/:id', (req, res) => {
  Libary.update({ _id: req.params.id }, //This is the Id of library Document
  { $pull: { "Books": {"_id":2) } } }) // This will be the Id of book to be deleted
    .then(() => {
      //redirect
    });
});

Hope it helps.

answered Mar 17, 2018 at 14:10

Rohail Najam

1,0411 gold badge8 silver badges12 bronze badges

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

2 Comments

ipid Over a year ago

Thanks a lot. Btw, does it matter if I use quotation marks or not? Like at "Books".

Rohail Najam Over a year ago

In Javascript it doesn't . I tested this query on mongo shell and copied it from there.

ema · Accepted Answer · 2018-03-17 14:02:54Z

2

You need to use $pull:

Library.update(
  { },
  { $pull: { Books: { _id: 2 } } }
)

answered Mar 17, 2018 at 14:02

ema

5,7931 gold badge28 silver badges32 bronze badges

Collectives™ on Stack Overflow

Delete id within nested array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related