🚀 Harness AI to execute your million-dollar ideas 10x faster, with 1/10th the effort.Get Started

update or add a property to subdocuments of all found documents (MongoDB)

9/25/2022

This updateMany finds all agreement_versions that has a participants property on it and sets each member (the $[] selects each individual member) of participants to have a field called role with a value of "Decider".

db.agreement_versions.updateMany(
  {
    participants: {
      $exists: true,
    },
  },
  {
    $set: {
      "participants.$[].role": "Decider",
    },
  }
);

Chase Adams