and more in a single search tool across platforms. Read the announcement here. |
02/15/2024 08:07 PM
Hi,
We are facing an issue in account name rule generation.
Current configuration-
CONCAT(substring(REPLACE(USERS.FIRSTNAME, ' ', ''),1,15), '_', substring(REPLACE(USERS.LASTNAME, ' ', ''),1,15)) #
CONCAT(substring(REPLACE(USERS.FIRSTNAME, ' ', ''),1,15), '_', substring(REPLACE(USERS.LASTNAME, ' ', ''),1,15), FN_EIC_SEQGEN('inc'))
We already have an account with the same name present in endpoint, still when creating an account for new user it picks same name for account creation and doesn't move to second rule evaluation.
As per my understanding account name is evaluated on endpoint level and not on same user existing access.
Thanks
02/15/2024 08:34 PM
try
CASE
WHEN CONCAT(substring(REPLACE(USERS.FIRSTNAME, ' ', ''),1,15), '_', substring(REPLACE(USERS.LASTNAME, ' ', ''),1,15)) IS NOT NULL
THEN CONCAT(substring(REPLACE(USERS.FIRSTNAME, ' ', ''),1,15), '_', substring(REPLACE(USERS.LASTNAME, ' ', ''),1,15), FN_EIC_SEQGEN('inc'))
END
02/15/2024 08:41 PM
Hi @rushikeshvartak, We don't want to append numbers if it is a unique/first time user profile.
as per my understanding it should fail the first rule evaluation as for another user account exist and then evaluate second rule and generate account name
02/15/2024 08:42 PM
Yes that should happen
Can you check logs when form is loaded
02/15/2024 08:50 PM
I did.. it evaluates the first one and says selectedaccountname based on first rule.
02/15/2024 08:56 PM
share logs
02/15/2024 09:04 PM
Made some changes in account name rule, as it will be the final to be utilized.
logs below-
02/16/2024 05:26 AM
Hi @rushikeshvartak ,
I removed the advance config and configured it again, Still the same thing.