Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
04/12/2022 01:03 PM
Below is screenshot of logic:
Solved! Go to Solution.
04/12/2022 02:15 PM
Hi Shashank,
With basic, we can configure in lower case. There is a hack for it i.e. go to DB , query configuration table and make change for the rule.
For example if your rule is users.username then just add lower(rule as created in db).
final would be lower(users.username).
Thanks
Ajay
04/12/2022 02:15 PM
Can you please share more details.
We have logic like for firstname and lastname
userlogin for first distinct user: flastname
userlogin for next distinct user filastname
userlogin for next distinct user firlastname
04/12/2022 02:15 PM
Hi,
Below is the rule to generate systemusername rule in lower case. You will have to add this to DB directly.
lower(concat(substring(users.firstname,1,1) , users.lastname) # concat(substring(users.firstname,1,2) , users.lastname) # concat(substring(users.firstname,1,2) , users.lastname) )
Thanks
Ajay