How to replace an item in an array in an aggregation?

Cyril_Auburtin1 · 2025-03-06T19:55:04.868Z

Say I’d like to replace one ID by another inside an array (the targetfield )

const id1 = new ObjectId(), id2 = new ObjectId(), id3 = new ObjectId();
await coll.insertMany([
  { targets: [id1, id2] },
  { targets: [id1] },
  { targets: [id2] },
]);
await coll.aggregate([
  { $set: { target: {.... } } } // replace all id1 by id3
])
// desired output for coll.find()
/*[
  { targets: [id3, id2] },
  { targets: [id3] },
  { targets: [id2] },
]*/

Could you guide me on what the aggregation operator should be?

Jack_Woehr · 2025-03-07T02:11:32.549Z

stackoverflow.com

MongoDB Replace specific array values

arrays, mongodb

asked by MarcL on 03:14PM - 31 Jan 18 UTC

system · 2025-03-12T04:47:26.355Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.