Please suggest a solution for updating an elemnt inside of an object array which is also insided of an array object

Working with Data
1

This is the structure of my db,
I want to update the status for each as placed, updated and canceled.

{
  "_id": {
    "$oid": "633ab3c11e6e97b6332f56a1"
  },
  "orders": [
    {
      "date": "6/10/2022",
      "productDetails": {
        "0": {
          "name": "Top",
          "price": "1235",
          "quantity": 1,
          "status": "placed"
        },
        "1": {
          "name": "Shirt",
          "price": "1235",
          "quantity": 1,
          "status": "placed"
        }
      },
      "billingAddress": {
        "address": "My Address",
        "city": "City",
        "state": "State",
        "country": "Country",
        "pincode": "123456",
        "contact": "1234567890"
      },
      "paymentMode": "cod"
    },
    {
      "date": "6/10/2022",
      "productDetails": {
        "0": {
          "name": "Top",
          "price": "1235",
          "quantity": 3,
          "status": "placed"
        },
        "1": {
          "name": "Shirt",
          "price": "1235",
          "quantity": 1,
          "status": "placed"
        }
      },
      "billingAddress": {
        "address": "My Address",
        "city": "City",
        "state": "State",
        "country": "Country",
        "pincode": "123456",
        "contact": "1234567890"
      },
      "paymentMode": "cod"
    },
    {
      "date": "6/10/2022",
      "productDetails": {
        "0": {
          "name": "Shirt",
          "price": "234",
          "quantity": 1,
          "status": "placed"
        },
        "1": {
          "name": "Top",
          "price": "123",
          "quantity": 1,
          "status": "placed"
        }
      },
      "billingAddress": {
        "address": "My Address",
        "city": "City",
        "state": "State",
        "country": "Country",
        "pincode": "123456",
        "contact": "1234567890"
      },
      "paymentMode": "cod"
    }
  ]
}
3

Hello @Muhammed_Sibly_B,

Welcome to The MongoDB Community Fourms! :wave:

Can you please provide below details for me to direct you towards a solution for your requirement?

  • MongoDB Version
  • Expected output document

Regards,
Tarun