We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

AdvQuery SystemUsername AutoIncrement

sandeepverma
Regular Contributor
Regular Contributor

Hi Experts,

As per docs https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter06-EIC-Configurations/Config...

FN_EIC_SEQGEN('USER_SYS') we can use for autoincrement in advanced query, it's working but not as expected.  

sandeepverma_0-1687333390030.png

sandeepverma_1-1687334108049.png

Suppose here ID =4 so in any next duplicate autoincrement will be 5, 6, 7.........

It's not like that it checks first combination then increment. and for new duplicate combination it should start with 1.

 

Thanks

1 REPLY 1

sudeshjaiswal
Saviynt Employee
Saviynt Employee

Hello @sandeepverma,

Can you try using RAND() instead of FN_EIC_SEQGEN and see if that helps?

Sample Query: 
System Username Generation with random numbers excludig 0 and 1:
CONCAT(SUBSTRING(lastname,1,6),SUBSTRING(firstname,1,1),(FLOOR(RAND() * (9-2 + 1)) + 2))

Thanks,