Question

3
Replies
15426
Views
 Vinay Reddy Yadulla (VinayY88)
Infosys

Infosys
US
VinayY88 Member since 2015 10 posts
Infosys
Posted: March 2, 2017
Last activity: February 27, 2018
Posted: 2 Mar 2017 6:33 EST
Last activity: 27 Feb 2018 17:02 EST
Closed
Solved

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***

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 2 Mar 2017 7:26 EST
Venkateswarlu Sudarsi (venkateswarlusudarsi)
Incessant Technologies

Incessant Technologies
GB

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


 


 

Accepted Solution

Posted: 4 years ago
Posted: 2 Mar 2017 9:00 EST
Lakshmi Venkatesh Kakumani (kakul)
PEGA
Associate Technical Solutions Engineer
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