Remove element from array that is inside of another array in mongoose

Question

The problem is that i can't remove an attachment from an object, in mongoose, with the next schema.

var question=mongoose.Schema({
   _id:mongoose.Schema.Types.ObjectId
   answers:[{
     _id:mongoose.Schema.Types.ObjectId
     attachments:[
      _id:mongoose.Schema.Types.ObjectId
     ]
   }]
});

I try to remove an attachment from a document with the next code.

Question.update({ 
  _id: req.params.idQuestion, 
  'answers._id': req.params.idAnswer 
}, { 
  $pull: { 
    'answers.$.attachments':{_id:req.params.idAttachment}
  } 
}, function (err, updated) {
  if(err){
    return res.status(400).send(err);
  }
  else if(!updated.nModified){
    return res.status(400).send('Question hasn\t been updated.');
  }
  
  res.send(200);
  
});

I thought my query weren't correct and tried to do that in mongo shell. It worked perfectly.

db.questions.update({
  _id:ObjectId('xx'),
  'answers._id':ObjectId('yy')
},{
  $pull:{
    'answers.$.attachments':{_id:ObjectId('zz')}
  }
})

Someone can help me with this problem?

Mi Ke Bu · Accepted Answer · 2018-09-07 06:16:22Z

1

Try this:

var qid=req.params.idQuestion,
    aid=req.params.idAnswer;
//find
Question.find({ 
  _id: qid, 
  'answers._id': aid 
},{
   answers:1
},function(err,question){
   //change
   var answers=question.answers.filter(function(el){
          return el._id!=aid;
       });
   //update
   Question.update({
      _id: qid, 
   },{$set:{
      answers:answers
   }},function(err,updated){
      ...//your callback here
   });
});

edited Sep 7, 2018 at 6:16

answered Nov 20, 2015 at 11:53

Mi Ke Bu

2242 silver badges13 bronze badges

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

2 Comments

fabioDMFerreira Over a year ago

Are you suggesting to remove the attachment without using the mongoose object?

Mi Ke Bu Over a year ago

Yes. Find field, modify field, write field to db. Array, string or date... no matter

Collectives™ on Stack Overflow

Remove element from array that is inside of another array in mongoose

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related