Add a unique MongoDb ObjectId to each Object in an existing Array

Question

I have an existing document and I wish to add a unique Object Id to each of the transaction Array Objects.

{
_id: ObjectId(6086d7e7e39add6a5220d0a5),
firstName: "John"
lastName: "Doe"
transactions: [
  {
    date: 2022-04-12T09:00:00.000+00:00
    amount: 286.56
    type: "deposit"
    method: "Bank transfer"
  },
  {
    date: 2022-04-15T09:00:00.000+00:00
    amount: 120.23
    type: "withdrawal"
    method: "cash"
  }]
}

The outcome would be each transactions Object would have a unique ObjectId. I have tried the following query but it add the same ObjectId to all objects:

collection.updateMany({}, [
  {
    $set: {
      transactions: {
        $map: {
          input: "$transactions",
          in: {
            $mergeObjects: ["$$this", { _id: new mongo.ObjectId() }],
          },
        },
      },
    },
  },
]);

Can anyone see why I am getting the same ObjectId written to all of the Objects in the transactions array instead of unique Ids?

question is very similar to this

Takis
– Takis

2022-04-30 10:54:34 +00:00
Commented Apr 30, 2022 at 10:54 — Takis
– Takis, Commented Apr 30, 2022 at 10:54

Takis · Accepted Answer · 2022-04-30 10:59:31Z

1

The code new mongo.ObjectId() will run on the driver => 1 id for all.
You need the js to run on the server, one time for each member.

Try to replace the new mongo.ObjectId() with the bellow $function code that will run on the server.
In general we should avoid javascript, but i don't think we have an aggregate operator that generates ObjectId's.

Another alternative is to write all the $map function in javascript, again with the use of $function.

*$function requires MongoDB >=4.4

{
  "$function": {
    "body": "function () {return new ObjectId();}",
    "args": [],
    "lang": "js"
  }
}

edited Apr 30, 2022 at 10:59

answered Apr 30, 2022 at 10:54

Takis

8,7552 gold badges17 silver badges28 bronze badges

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

1 Comment

Phil Glen Over a year ago

Unfortunately, though I am using Mongo v5.0 it's on a free Atlas cluster which does not allow server side JavaScript.

Meelad Ghazipour · Accepted Answer · 2022-04-30 23:24:13Z

1

the _id field in a document cannot be modified.in fact you are tying to modify main objectid. try another name for your transaction_id field.

answered Apr 30, 2022 at 23:24

Meelad Ghazipour

363 bronze badges

3 Comments

Phil Glen Over a year ago

Could I use an ObjectId or should I generate a random number with Math.random() Or even better just increment by 1 for each object would be sufficient, I just need a way of identifying the object from another collection.

Meelad Ghazipour Over a year ago

there is a trick like adding a number to end of main object id .it helps readability or other usages in the future that probably you dont know about right now.but since your purpose is only making a unique value as you said , then dont spend time to engineering a small feature. just use math.random and go to next step.

Meelad Ghazipour Over a year ago

by the way math.random is math.random. its not math.unique ... !

Collectives™ on Stack Overflow

Add a unique MongoDb ObjectId to each Object in an existing Array

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related