update Nested Array value mongo

Question

Hello folks struggling with this updatation Any one can please help out here

  "sheet_types": [
    {
      "areas": [
        "FRONT",
        "SIDE",
        "UPPER"
      ]
    }
  ]
}

I need to update the value of UPPER to TOP here

I have tried this query

db.company_settings.updateOne(
   {"sheet_types.areas": "UPPER" },
   { $set: {   "sheet_types.$.areas" : "TOP" } })

But the result i getting is

{
  "sheet_types": [
    {
      "areas": [
        "TOP"
      ]
    }
  ]
}

R2D2 · Accepted Answer · 2022-10-10 19:15:07Z

1

Using "arrayFilters" seems to fit best for this use case:

db.collection.update({},
  {
   "$set": {
     "sheet_types.$[].areas.$[filter]": "TOP"
   }
  },
  {
  "arrayFilters": [
     {
       "filter": "UPPER"
     }
   ]
 })

Explained:

Add arrayFIlter with one filter element equal to the value that you need to replace , use this filter to replace the value in the update statement. The advantage of this option is that it will replace all matching values that match the filter conditions in the document.

playground

answered Oct 10, 2022 at 19:15

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

update Nested Array value mongo

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