and more in a single search tool across platforms. Read the announcement here. |
01/11/2023 08:42 AM
Hello,
I am creating Advanced Query Username Generation Rule and my users.firstname is not returning the correct value. Instead of getting the user's first name, it returns the advanced query. My query is below and it will allways generate a name "c<Last Initial>1234"
concat(substring(users.firstname,1,1), substring(users.lastname,1,1), substring(users.employeeid,-4))
I changed the query to firstname,1,10 and realized it was returning the advanced query
concat(substring(users.firstname,1,10), substring(users.lastname,1,1), substring(users.employeeid,-4))
concatsubs<Last Initial>1234
Any help figuring out how to properly return the user's first initial would be appreciated.
Thanks,
Stanford
Solved! Go to Solution.
01/11/2023 08:46 AM - edited 01/11/2023 08:48 AM
What should be username format ?
concat(left(users.firstname,1), left(users.lastname,1), right(users.employeeid,4))
01/11/2023 09:48 AM
That fixed the issue, I think the advanced query didn't like the substring(employeeid,-4) I changed it to substring(employeeid,3,6) and it properly returned the first initial.