Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

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

Avatar

Level 2

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.

 

Sathyam_Chandan_0-1701349232202.png

Regards

Satya

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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-sche...

 

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

 

Regards,

Craig

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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-sche...

 

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

 

Regards,

Craig