and more in a single search tool across platforms. Read the announcement here. |
05/08/2023 07:02 PM
Hello,
I am seeking help on meeting the custom email generation rule in the new 23.3 env.
The Requirements are as follows:
1. Generate email address only for users from specific Org Unit IDs, say Corp, Contract, etc.
2. Check customproperty21 (we use this for capturing any email aliases - emails that users have used in the past) for uniqueness
3. Remove any special characters i.e. first'name, lastname becomes firstname.lastname@abc.com
4. Generate emails for users who have same firstname and lastname, incrementally, i.e. john.wayne@abc.com, john.wayne2@abc.com
Not sure on how to satisfy all these using just the Advanced Config.
Any ideas?
05/09/2023 04:33 AM
Hi @smadabh
Did you try put all this condition in advance sql query
1. Generate email address only for users from specific Org Unit IDs, say Corp, Contract, etc- if its stored in some specific attribute, you can make use of it based on case conditions
2. Check customproperty21 (we use this for capturing any email aliases - emails that users have used in the past) for uniqueness- same as above use case conditions
3. Remove any special characters i.e. first'name, lastname becomes firstname.lastname@abc.com.
Make use of OOTB functions ( use of datasets )- https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter02-Identity-Repository/Datab...
4. Generate emails for users who have same firstname and lastname, incrementally, i.e. john.wayne@abc.com, john.wayne2@abc.com
Use # to write multiple sql query based on case conditions, if it matches it goes for next rule and append it to 1.
Note: sample sql can be found in the documentation
Thanks
Darshan
05/17/2023 11:37 PM
Thank you for the response.
We were able to accomplish 1 & 4.
Still struggling with 2 & 3.
For 3, is there an example of where in the SQL query we can use the FN_ function?
05/18/2023 04:48 AM
These are the OOTB functions and can be used in inline processing , analytics or custom property job.
Thanks
Darshan