how to update all objects within an array that has matching values?

Question

I have a couple of inserts for a collection:

db.customerOrder.insert (
{
  "orders": [
    {
      "orderNumber": "ord003",
      "orderDate": ISODate("2020-01-10T00:00:00Z"),
      "staffNumber": "stf789",
    },
    {
      "orderNumber": "ord005",
      "orderDate": ISODate("2020-03-17T00:00:00Z"),
      "staffNumber": "stf444",
    },
    {
      "orderNumber": "ord005",
      "orderDate": ISODate("2020-02-22T00:00:00Z"),
      "staffNumber": "stf890",
    }
  ]
}
);

db.customerOrder.insert (
{
  "orders": [
    {
      "orderNumber": "ord001",
      "orderDate": ISODate("2020-04-23T00:00:00Z"),
      "staffNumber": "stf123",
    },
    {
      "orderNumber": "ord005",
      "orderDate": ISODate("2020-04-16T00:00:00Z"),
      "staffNumber": "stf444",
    }
  ]
}
);

db.customerOrder.insert (
{
  "orders": [
    {
      "orderNumber": "ord001",
      "orderDate": ISODate("2020-02-10T00:00:00Z"),
      "staffNumber": "stf123",
    },
    {
      "orderNumber": "ord005",
      "orderDate": ISODate("2020-04-10T00:00:00Z"),
      "staffNumber": "stf890",
    }
  ]
}
);

db.customerOrder.insert (
{
  "orders": [
    {
      "orderNumber": "ord005",
      "orderDate": ISODate("2020-05-15T00:00:00Z"),
      "staffNumber": "stf123",
    },
    {
      "orderNumber": "ord004",
      "orderDate": ISODate("2020-02-25T00:00:00Z"),
      "staffNumber": "stf890",
    }
  ]
}
);

These were inserted through a terminal, I am not using any server sided language like php and etc, just data manipulation using the terminal.

May I know how I can change the stfNumber to stf100 for all orderNumber with ord005?

I have tried this

db.customerOrder.update({"orders.orderNumber":"ord005"},{"$set":{"orders.$.staffNumber":"stf100"}})

Unfornately, only the first object with ord005 is updated with the staffNumber to stf100

Mohammed Yousry · Accepted Answer · 2020-05-24 17:29:08Z

1

You can use the filtered-Positional array update operator

your query may look something like this

db.customerOrder.updateMany(
    { "orders.orderNumber": "ord005" }, // filter part
    { "$set": { "orders.$[order].staffNumber": "stf100" } }, // update part
    { arrayFilters: [{ 'order.orderNumber': 'ord005' }] } // options part, to define which orders will be updated according to some condition
)

hope it helps

edited May 24, 2020 at 17:29

answered May 24, 2020 at 17:00

Mohammed Yousry

2,1841 gold badge8 silver badges7 bronze badges

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

2 Comments

Astoach167 Over a year ago

it only updates all occurrences in the first document :(

Mohammed Yousry Over a year ago

okay, I have updated my answer, we need to use updateMany instead of update, I tested it in mongo shell, and it's working as expected, could you check it again?

Collectives™ on Stack Overflow

how to update all objects within an array that has matching values?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related