Primary key should be increment sequentially like HDFC001, HDFC002, HDFC03...... | Community
Skip to main content
Sathyam_Chandan
Sathyam_Chandan
Level 2
November 30, 2023
Solved

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

  • November 30, 2023
  • 1 reply
  • 732 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
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

 

    Terms & ConditionsAccessibility statement

    Loading footer...