MongoDB - Unable to add timestamp fields to subdocuments in an array

Question

I recently updated my subschemas (called Courses) to have timestamps and am trying to backfill existing documents to include createdAt/updatedAt fields.

Courses are stored in an array called courses in the user document.

// User document example

{
name: "Joe John",
age: 20,
courses: [
    {
      _id: <id here>, 
      name: "Intro to Geography", 
      units: 4
    } // Trying to add timestamps to each course
  ]
}

I would also like to derive the createdAt field from the Course's Mongo ID.

This is the code I'm using to attempt adding the timestamps to the subdocuments:

db.collection('user').updateMany(
    {
      'courses.0': { $exists: true },
    },
    {
      $set: {
        'courses.$[elem].createdAt': { $toDate: 'courses.$[elem]._id' },
      },
    },
    { arrayFilters: [{ 'elem.createdAt': { $exists: false } }] }
  );

However, after running the code, no fields are added to the Course subdocuments.

I'm using mongo ^4.1.1 and mongoose ^6.0.6.

Any help would be appreciated!

$toDate is an aggregation function, you can use it only in an aggregate but not in updateMany — Wernfried Domscheit
– Wernfried Domscheit, Commented Dec 11, 2021 at 6:40

Joe · Accepted Answer · 2021-12-11 22:08:32Z

0

Using aggregation operators and referencing the value of another field in an update statement requires using the pipeline form of update, which is not available until MongoDB 4.2.

Once you upgrade, you could use an update like this:

db.collection.updateMany({
  "courses": {$elemMatch: {
        _id:{$exists:true}, 
        createdAt: {$exists: false}
   }}
 },
 [{$set: {
      "courses": {
        $map: {
          input: "$courses",
          in: {
            $mergeObjects: [
              {createdAt: {
                  $convert: {
                    input: "$$this._id",
                    to: "date",
                    onError: {"error": "$$this._id"}
                  }
               }},
               "$$this"
            ]
          }
        }
      }
    }
  }
])

edited Dec 11, 2021 at 22:08

answered Dec 11, 2021 at 9:11

Joe

29k4 gold badges25 silver badges50 bronze badges

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

1 Comment

Jan Over a year ago

This is exactly what I needed, thanks so much! I've learned a lot more about Mongo today.

Collectives™ on Stack Overflow

MongoDB - Unable to add timestamp fields to subdocuments in an array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related