How to update an Array of Objects field in MongoDb

Question

I have a data structure, like so

{
  _id: '',
  name: 'A',
  financialReports: {
    monthlyBill: 20,
    monthlyBillReports: [
      {
        month: 'JAN',
        isPaid: true
      },
      {
        month: 'FEB',
        isPaid: false
      },
      {
        month: 'MAR',
        isPaid: false
      },
      {
        month: 'APR',
        isPaid: false
      },
      ...
    ]
  }
},
...

How should I dynamically update financialReports.monthlyBillReports[i].isPaid to true? I got array of data that indicate to month field in Database from front-end ['FEB', 'APR'], But I am not sure if I could iterate over the array and make update query to Database.

Karl L · Accepted Answer · 2020-06-11 04:51:12Z

1

you can do a loop something like:

let yourArray = ['FEB', 'APR'] // just mocking the array

yourArray.forEach((mo)=>{
      collectionName.findOneAndUpdate( 
             {_id: 'document id goes here'},
             { '$set': {'financialReports.monthlyBillReports.$[frFilter].isPaid': true}},
             { arrayFilters: [ {frFilter.month: mo} ], multi: true}
          ).then(
                //do whatever you need here
          )
    })

or in a more straight forward manner:

collectionName.findOneAndUpdate( 
                 {_id: 'document id goes here'},
                 { '$set': {'financialReports.monthlyBillReports.$[frFilter].isPaid': true}},
                 {arrayFilters: [ {frFilter.month: {$in: yourArray} } ], multi: true}
              ).then(
                    //do whatever you need here
              )

edited Jun 11, 2020 at 4:51

answered Jun 9, 2020 at 5:30

Karl L

1,7251 gold badge9 silver badges11 bronze badges

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

5 Comments

venmdev Over a year ago

It works but instead of changing isPaid to true It writes a new isPaid: true So i got two isPaid which have value false and true respectively, How to fix this ? thank you for your help by the way

Karl L Over a year ago

sorry, ive edited the code. there was a space between $[frFilter]. and isPaid, ive removed that. just make sure remove the other isPaid fields first, before running it again

Karl L Over a year ago

and oh, should be financialReports.monthlyBillReports.$[frFilter] instead

Ilijanovic Over a year ago

why you dont go with updateMany and filter it like this arrayFilters: [ {frFilter.month: { $in: ["FEB", "APR"] }} ] so you dont need to go with a forEach

Karl L Over a year ago

that will work too arrayFilters: [ {frFilter.month: {$in: yourArray} } ], i think there is no need for updateMany as it only affects one document

Collectives™ on Stack Overflow

How to update an Array of Objects field in MongoDb

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related