First Name Incorrect Value - Username Generation Advanced Querry

[sfinney]

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

[rushikeshvartak · Accepted solution]

What should be username format ?

concat(left(users.firstname,1), left(users.lastname,1), right(users.employeeid,4))

[sfinney]

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.