How to generate 10 digit unique ID in sequential order
Hi All,
I have a requirement to generate unique ID with 10 digits, please let me know if any one has any idea on doing it. GenerateID activity create unique ID but we cannot define the ID length.
Regards,
Vinay
***Moderator Edit: Vidyaranjan | Updated Categories***
Accepted Solution
Pegasystems Inc.
IN
If the requirement is changing the WorkObject ID to start from 1000000000 i.e W-1000000001, then you can try changing the corresponding value of pyLastReserved column value in the pc_data_uniqueid table.
When generating the unique WO id, it internally calls stored procedures sppc_data_uniqueid which inturn calls sppc_data_uniqueid_withouttran. This checks the value of pyLastReserved of pc_data_uniqueid and it increments value by 1every time.
Regards,
Venkatesh.K.L
Virtusa
IN
You need to write utility for achieving this.write java code for generating 10 digit unique random number.
Long unique=(long) Math.floor(Math.random() * 9000000000L) ;
thanks..
J.P. Morgan Services India PVT Ltd
IN
Got some link related to this, can this help?
https://collaborate.pega.com/question/generate-unique-id-primary-key-data-table
Accepted Solution
Pegasystems Inc.
IN
If the requirement is changing the WorkObject ID to start from 1000000000 i.e W-1000000001, then you can try changing the corresponding value of pyLastReserved column value in the pc_data_uniqueid table.
When generating the unique WO id, it internally calls stored procedures sppc_data_uniqueid which inturn calls sppc_data_uniqueid_withouttran. This checks the value of pyLastReserved of pc_data_uniqueid and it increments value by 1every time.
Regards,
Venkatesh.K.L