update multiple elements in array mongodb

Question

I want to update chargeList isDelete property to true when date is greater than a specific value. my schema as follows.

{
   "chargeList": [
     { 
         "date": ISODate("2013-06-26T18:57:30.012Z"),
         "price": "123",
         "isDelete": false

     },
     { 
         "date": ISODate("2013-06-27T18:57:30.012Z"),
         "price": "75",
         "isDelete": false

     }
   ]
 }

schema is as follows.

var ChargeListSchema= new Schema({
    date:  { type: Date , default: Date.now  },
    price: { type: String, required: false },
    isDelete: { type: Boolean, default: false }
});

var ScheduleChargeSchema = new Schema({

  chargeList:[ChargeListSchema]


  });

I have tried as following code but it only update the matching first element in chargeList array.

 Model.update(
  {
    "_id": 1,
    "chargeList": {
      "$elemMatch": {
        "date": {
           $gt:  ISODate("2013-06-26T18:57:30.012Z")
        }
      }
    }
  },
  {
    "$set": { "chargeList.$.isDelete": true }
  }
)

Ashh · Answer 1 · 2018-07-11T17:15:08.067

1

You need to use $[] all positional operator to update multiple elements in an array

Model.update(
  { "_id": 1, "chargeList.date": { "$gt":  ISODate("2013-06-26T18:57:30.012Z") }},
  { "$set": { "chargeList.$[].isDelete": true } }
)

edited Jul 11 '18 at 17:15

answered Jul 11 '18 at 07:48

Ashh

44,693
14
105
132

that doesnot update anyone of record. – Manoj Sanjeewa Jul 11 '18 at 09:06
It does work ... Please check your conditions there... Or post your schema... – Ashh Jul 11 '18 at 09:13
added the schema to the post. – Manoj Sanjeewa Jul 11 '18 at 09:32
and my mongoose version is 4.11.6. – Manoj Sanjeewa Jul 11 '18 at 09:41
@ManojSanjeewa what is your mongodb version? – Ashh Jul 11 '18 at 09:51
mongodb version 3.6.3 – Manoj Sanjeewa Jul 11 '18 at 10:00
@ManojSanjeewa It is working for me and it should work for you... Please check the conditions and criteria please... – Ashh Jul 11 '18 at 10:02
@ManojSanjeewa Ok Do one thing remove your all the condition and criteria and try simply `Model.update( { "_id": 1 }, { "$set": { "chargeList.$[].isDelete": true } } )` – Ashh Jul 11 '18 at 10:03
remove the criteria to { "_id": 1 } still not working, { "$set": { "chargeList.$.isDelete": true } } is still working but updates only one. – Manoj Sanjeewa Jul 11 '18 at 10:11
Ok got it... Update your mongoose version to 5.x – Ashh Jul 11 '18 at 10:14
cannot upgrade becuase the project' s some mongoose functionalities not compatible with new version. – Manoj Sanjeewa Jul 11 '18 at 10:26
Actually mongodb version 3.6 is not compatible with mongoose 4.x you have to upgrade in order to use $[] positional operator and I think all functions of 4.x are available with 5.x... So don't worry – Ashh Jul 11 '18 at 10:28
are you sure is it version problem? what is the workaround for the previose versions. – Manoj Sanjeewa Jul 11 '18 at 10:28
1

You can see this https://stackoverflow.com/questions/51244687/update-multiple-elements-in-an-array/51244726#51244726 and this https://stackoverflow.com/questions/51206841/update-multiple-elements-in-an-array-in-mongodb/51208305#51208305 – Ashh Jul 11 '18 at 10:32

update multiple elements in array mongodb

1 Answers1

Linked