Updating array list in Mongo DB

Question

I want to update the Status field inside array list of Slots where id = "".

Sample data

{
  "_id": ObjectId("621e816e7a938400016c5c64"),
  "Resource": "[email protected]",
  "School": {
    "Class": [
      {
        "Type": "ABC",
        "Slots": [
          {
            "id": "",
            "Duration": "1 week",
            "Status": "Released",
            "Selected": true
          },
          {
            "id": "123",
            "Duration": "1 week",
            "Status": "Released",
            "Selected": true
          }
        ]
      }
    ]
  }
}

This is how I am approaching:

db.getCollection("XYZ").update({
  "Resource": "[email protected]",
  "School.Class": {
    "$elemMatch": {
      "Type": "ABC",
      "Slots.Status": "Released",
      "Slots.id": "",
      "Slots.Duration": "1 week"
    }
  }
},
{
  $set: {
    "School.Class.$[outer].Slots.$[inner].Status": "Confirmed"
  }
},
{
  "arrayFilters": [
    {
      "outer.Type": "ABC"
    },
    {
      "inner.Duration": "1 week"
    }
  ]
})

But it is updating the status as confirmed for the both the array list.How can I update the particular field where "Slots.id" : "" . Please forgive me in case of any misalignment or brackets missing in data

J.F. · Accepted Answer · 2023-01-17 20:27:24Z

1

If I've understood correctly you are almost there, since you want to update only values where id is "" you have to add that condition into arrayFilters: "inner.id": "".

db.collection.update({
  "Resource": "[email protected]",
  "School.Class": {
    "$elemMatch": {
      "Type": "ABC",
      "Slots.Status": "Released",
      "Slots.id": "",
      "Slots.Duration": "1 week"
    }
  }
},
{
  $set: {
    "School.Class.$[outer].Slots.$[inner].Status": "Confirmed"
  }
},
{
  "arrayFilters": [
    {
      "outer.Type": "ABC"
    },
    {
      "inner.Duration": "1 week",
      "inner.id": ""  // <--- This line
    }
  ]
})

Example here

edited Jan 17, 2023 at 20:27

answered Jan 17, 2023 at 20:20

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

Updating array list in Mongo DB

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