Mongo Update a sub-document of an Array

Question

The collection... This is the structure of a collection i have. I want help with an update query.

{ 
  id: 1, 
  line_items: [
    {
      id: 43,
      review_request_sent: true
    }
  ]
},
{
  id: 2,
  line_items: [
    {
      id: 1,
      review_request_sent: false
    },
    {
      id: 39
    },
 ]
},
{
  id: 3,
  line_items: [
    {
     id: 23,
     review_request_sent: true
    },
    {
     id: 85,
     review_request_sent: true
    },
    {
     id: 12,
     review_request_sent: false
    }
  ]
}

I would like help with an updating document. Let say update the review_request_sent to true where the id is 3 and line_item's object id is 12.

So the last document becomes

{
  id: 3,
  line_items: [
    {
     id: 23,
     review_request_sent: true
    },
    {
     id: 85,
     review_request_sent: true
    },
    {
     id: 12,
     review_request_sent: true
    }
  ]
}

Answer 1

You can use the $ positional operator:

Model.update(
    { 'id': 3, 'line_items.id': 12 }, 
    { $set: { 
        'line_items.$.review_request_sent': false
    }}, function (err, numAffected) { ... }
);