AdvQuery SystemUsername AutoIncrement

[sandeepverma]

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.  

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

[sudeshjaiswal]

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,