Hi everyone,
I have a usecase where I have to generate username based on a customproperty of a user. When the user will get imported either via a connection or via CSV file, there will be a value in the customproperty40 of that user. The usecase to generate the username will go like(using advanced config):
if customproperty40 = abc company name, username: firstname.lastname@abc.com or
if customproperty40 = def company name, username: firstname.lastname@def.com or
if customproperty40 = ghi company name, username: firstname.lastname@ghi.com or
if customproperty40 = jkl company name, username: firstname.lastname@jhl.com or
if customproperty40 = mno company name, username: firstname.lastname@mno.com
I am able to achieve this usecase via this query:
case when (users.customproperty40 = 'abc company name' ) then concat(users.firstname, '.', users.lastname, '@abc.com')
when (users.customproperty40 = 'def company name' ) then CONCAT(users.firstname, '.', users.lastname, '@def.com')
when (users.customproperty40 = 'ghi company name' ) then CONCAT(users.firstname, '.', users.lastname, '@ghi.com')
when (users.customproperty40 = 'jkl company name' ) then CONCAT(users.firstname, '.', users.lastname, '@jkl.com')
when (users.customproperty40 = 'mno company name' ) then CONCAT(users.firstname, '.', users.lastname, '@mno.com') end
Now the thing is if an user comes along where the firstname and the lastname of that user is same to an already existing user, the user will not get created, this applies to all the five domains. I want to add autoincrement in such case where if the user has the same first and lastname of the exsiting user then the new user's username be like:
firstname.lastname1@abc.com or
firstname.lastname1@def.com or
firstname.lastname1@ghi.com or
firstname.lastname1@jkl.com or
firstname.lastname1@mno.com
Can anyone help me achieve this?
Best Regards,
Thank you.
