Migrating data to _id fields

kariyngva

2 months ago

7

await db.collection('tags').updateMany({}, [{ $set: { _id: '$name.is' } }]);

• 

  thisisnotchris

  2 months ago

  @kariyngva I'm pretty sure

  _id

  is reserved and shouldn't be edited

  
  

  
  

  In any case, I would suggest reverting those changes and picking a different property name

• 

  kariyngva

  2 months ago

  Well this is what you get when using Custom IDs:

  https://payloadcms.com/docs/fields/overview#customizable-id
  
  

  When you set a field name to

  id

  it becomes

  _id

  . The issue here is migrating the

  name

  value i.e.

  test

  to be the id 🙂

• 

  Jarrod

  Payload Team

  last month

  If you are doing this just to ease querying, I would prob advise to keep the "advanced" query and set

  index: true

  on your name field.

• 

  kariyngva

  last month

  Thanks Jarrod, that makes sense 🙏

• 

  Teun

  last month

  If you do want to use the custom id field, then you'll have to write a custom migration for it. Mongo will not let you update an id. Only way to accomplish that is the create a new document with the required id and remove to old one.

• 

  kariyngva

  last month

  Yeah that's what I figured. Just wanted to check if anyone had a better solution. Thanks Tuen!