Notion app logo
Struggling to stay organized and effective? Learn to master your time and tasks with the Effectively Notion course!

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

How to update or add a property to subdocuments in MongoDB.

2022-09-26

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",
    },
  }
);

Photo of Chase Adams

Hey, I'm Chase. I help aspiring entrepreneurs and makers turn their ideas into digital products and apps.

Freebies

Vector Arrow Scribbles
banner image for figma vector arrows scribbles

A figma community project of vectorized hand-drawn arrows.

Go To Figma
Vector Line Scribbles
banner for figma vector line scribbles

A figma community project of vectorized hand-drawn lines.

Go To Figma
Vector Shape Scribbles
banner image of figma vector shapes scribbles

A figma community project of vectorized hand-drawn shapes.

Go To Figma

Subscribe to my Newsletter

Every other week I publish the Curiously Crafted newsletter.

In it, I explore the intersection of curiosity and craft: the people who make stuff, what they make and the way they pursue the craft of making.

Online

I'm on almost all social media as @curiouslychase.

The curious logo of Chase Adams: glasses and a bow tie.stay curious.