Mongodb remove object from array

Question

I am trying to remove an object form an array based on the name(Ticker) of an object. Others have also asked this question and I have tried many of their solutions but I just cant get it to work. It never actually performs the task of removing anything.

Here is my schema:

{
    _id : 1234 
    email : [email protected] 
    pass : password  
    stock : [ 
        {
        Ticker : TSLA 
        Market : Nasdaq 
        Notes : [ 
            "Buy at 700", 
            "Sell at 1000"
            ] 
        },
        {
        Ticker : AAPL 
        Market : Nasdaq 
        Notes : [ 
            "Buy at 110", 
            "Sell at 140"
            ] 
        },
    
    ]
}

Here is what I currently have, but I've also tried a few other combinations of commands:

router.post(`/watchlist/remove/:email/:pass/:stock`, (req, res) => {
    var email = req.params.email
    var pass = req.params.pass
    var tempStock = req.params.stock


    userModel.findOneAndUpdate({ email: email  }, { $pull : {'stock.Ticker' : tempStock} }   , (documents, err) => {
        if (err) {
            res.send(err);
        }
        else {
            res.send(documents)
        }
    })
})

Shivam · Accepted Answer · 2021-01-04 04:26:39Z

1

I think this might help

userModel.findOneAndUpdate({ email: email  }, { $pull:{stock:{Ticker : tempStock}}}, (documents, err) => {
        if (err) {
            res.send(err);
        }
        else {
            res.send(documents)
        }
    })

Also you might want to double-check if you are receiving value in tempStock variable

answered Jan 4, 2021 at 4:26

Shivam

3,6622 gold badges15 silver badges30 bronze badges

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

1 Comment

RashadArbab Over a year ago

I didn't realize earlier but the tempStock was receiving an object and not just a string. Thanks for the help your code worked once I sorted tempStock out.

Abhishek Pankar · Accepted Answer · 2021-01-04 06:39:16Z

0

Your query should be like this:

userModel.findOneAndUpdate({
    "email": email,
    "stock.Ticker": tempStock
}, {
    "$pull": {
        "stock": {
            "Ticker": tempStock
        }
    }
}, (documents, err) => {
    if (err) {
        res.send(err);
    }
    else {
        res.send(documents)
    }
})

answered Jan 4, 2021 at 6:39

Abhishek Pankar

7279 silver badges26 bronze badges

Collectives™ on Stack Overflow

Mongodb remove object from array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related