Primary key should be increment sequentially like HDFC001, HDFC002, HDFC03...... | Adobe Higher Education
Skip to main content
Sathyam_Chandan
Sathyam_Chandan
Level 2
November 30, 2023
解決済み

Primary key should be increment sequentially like HDFC001, HDFC002, HDFC03......

  • November 30, 2023
  • 1 の返信
  • 732 ビュー

Dear Community leaders,

 

Primary key should be generate sequentially. If I use autopk="true", it is incrementing randomly not sequentially. can you please which is the best way to generate unique primary key sequentially like below screenshot.

 

Regards

Satya

このトピックへの返信は締め切られました。
ベストアンサー Craig_Thonis

Hi Sathyam,

Please look at the thread below, which covers incremental logic and explains that the incremental increase isn't incrementing by 1 because the original logic was in place to jump by 30 or so to lower the risk of duplicate IDs.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/autopk-in-the-schema-is-not-incrementing-properly-when-used/m-p/611211#M19137

 

If you need to change this logic then you will need to define your own sequence.

 

Regards,

Craig

 

1 の返信

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee回答
Adobe Employee
November 30, 2023

Hi Sathyam,

Please look at the thread below, which covers incremental logic and explains that the incremental increase isn't incrementing by 1 because the original logic was in place to jump by 30 or so to lower the risk of duplicate IDs.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/autopk-in-the-schema-is-not-incrementing-properly-when-used/m-p/611211#M19137

 

If you need to change this logic then you will need to define your own sequence.

 

Regards,

Craig

 

    契約条件Accessibility statement

    Loading footer...