Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/25/2024 02:47 PM
Hello
I am encountering an issue where the employee ID is not incrementing anymore when trying to create consultant account
i m using this query
select concat('X',LPAD(COALESCE(max(right(employeeid,length(employeeid)-1))+1,'1'),7,'0')) as ID from users where employeeid is not null and customproperty10='Externe'
however it s getting stuck with the current number.
could you please assist
10/25/2024 03:28 PM