How to remove an object from an array using Mongoose

Question

I have tried a lot of things but can't seem to get any of them to work as intended. Let's say I had something like the following.

{
      _id: '12345',
      name: 'John Smith',
      job: [
        {
             title: 'Web Developer',
             years: '12',
             status: 'not active',
         },
         {
             title: 'supervisor',
             years: '15',
             status: 'terminated',
         },
         {
             title: 'lead developer',
             years: '3',
             status: 'not active',
         },
         {
             title: 'Software Engineer',
             years: '9',
             status: 'active',
         },
      ]
 }

How can I remove the object with the status of 'terminated'? Also, would it be the same to remove all objects with that status of 'not active'?

Thanks.

None of the following work. I am using Mongoose.

j15
– j15

2020-07-17 15:20:28 +00:00
Commented Jul 17, 2020 at 15:20 — j15
– j15, Commented Jul 17, 2020 at 15:20

Dori Lahav Waisberg · Accepted Answer · 2020-07-17 14:22:52Z

2

You can use findOneAndUpdate with the $pull command.

Example:

User.findOneAndUpdate({/* filter */}, { $pull: {array: {/* condition */}} });

More information:

$pull

answered Jul 17, 2020 at 14:22

Dori Lahav Waisberg

9805 silver badges11 bronze badges

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

Comments

Krishna · Accepted Answer · 2020-07-17 14:35:02Z

0

Wondering if the below would work as well....

Model.findOneAndUpdate({'job.status' : "terminated"}, { $pull: job.$ }, {$multi : true});

answered Jul 17, 2020 at 14:35

Krishna

651 gold badge1 silver badge7 bronze badges

1 Comment

Krishna Over a year ago

you will have to give people the exact error that you are getting, so somebody can help.

Kunal Mukherjee · Accepted Answer · 2020-07-17 14:59:47Z

0

Remove nested document using the $pull operator

var query = {
    _id: "12345"
};

var update = {
    $pull: {
        job: {
            status: {
                $in: ['terminated', 'not active']
            }
        }
    }
};

db.collection.update(query, update);

answered Jul 17, 2020 at 14:59

Kunal Mukherjee

5,8733 gold badges29 silver badges55 bronze badges

3 Comments

Kunal Mukherjee Over a year ago

It works

Kunal Mukherjee Over a year ago

@j15 What is the exact code you tried, and what error are you getting in the console, please update the question

j15 Over a year ago

I figured it out, jsut had to make a simple change.,

Collectives™ on Stack Overflow

How to remove an object from an array using Mongoose

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related