update a nested array with a array of id in mongoose

Question

I have an object that looks like this.

_id: objectId,
vip:
  [
    { 
       uid:{type: Schema.Types.ObjectId, ref: 'User'},
       time:Date,
       paid:{type:Boolean,default:false}
     }
 ]

My goal is to mark vip.$.paid to be true by providing a array of uid in mongoose node.js

I know that to update one single document with one uid parameter is like this

User.findOneAndUpdate({_id:id,"vip.$.uid":uid}, {$set: {"vip.$.paid" :  true}})

but given a array of uids, updating the nested documents could be simply like

   for (uid in uids){
      User.findOneAndUpdate({_id:id,"vip.$.uid":uid}, {$set: {"vip.$.paid" :  true}})
   }

but this is not effecient enough, how would I accomplish this ?

Cuong Le Ngoc · Accepted Answer · 2019-07-15 12:47:13Z

1

You can use $in operator in mongodb to do this.

Sample:

User.findOneAndUpdate({_id: id, "vip.$.uid": {$in: uids}}, {$set: {"vip.$.paid" :  true}})

answered Jul 15, 2019 at 12:47

Cuong Le Ngoc

12k2 gold badges23 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

update a nested array with a array of id in mongoose

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related