Mongoose - remove multiple documents in one function call

Question

In documentation there's deleteMany() method

Character.deleteMany({ name: /Stark/, age: { $gte: 18 } }, function (err) {});

I want to remove multiple documents that have one common property and the other property varies. Something like this:

Site.deleteMany({ userUID: uid, id: [10, 2, 3, 5]}, function(err) {}

What would be the correct syntax for this?

score 101 · Accepted Answer · answered Jun 09 '17 at 22:08

101

I believe what youre looking for is the $in operator:

Site.deleteMany({ userUID: uid, id: { $in: [10, 2, 3, 5]}}, function(err) {})

answered Jun 09 '17 at 22:08

Kevin

7

you can omit `$in`, just `id: [10, 2, 3, 5]` – Rami Chasygov Jul 18 '19 at 19:51

laxman · Answer 2 · 2019-09-05T09:31:53.627

21

You can also use.

Site.remove({ userUID: uid, id: { $in: [10, 2, 3, 5]}}, function(err, response) {});

edited Sep 05 '19 at 09:31

answered Jun 10 '17 at 06:34

laxman

12

it is deprecated in Mongoose 5.x, deleteMany should be used there – Darin Kolev Sep 10 '18 at 10:06

score 11 · Answer 3 · answered Oct 06 '19 at 13:27

I had to change id to _id for it to work:

Site.deleteMany({ _id: [1, 2, 3] });

This happens if no id is defined and the default one is used instead:

"Mongoose assigns each of your schemas an _id field by default if one is not passed into the Schema constructor." mongoose docs

score 7 · Answer 4 · edited Jun 23 '19 at 13:41

7

Yes, $in is a perfect solution :

Site.deleteMany({ userUID: uid, id: { $in: [10, 2, 3, 5] } }, function(err) {})

edited Jun 23 '19 at 13:41

Amr Saber

answered May 27 '19 at 01:48

Ramana V V K

4 Answers4