Advanced query Account name rule

[RutujaM]

Hi, I need to create account name rule for the condition: 

Prefix (8661) 1st 5 letters of lastname and 1st letter of Firstname. eg for user:

Firstname: Alexandra and Lastname: Hernandez

Account name should be: 8661hernaA

[Manu269]

Can you share what you have built?

Sample for some :

Solved: Accountname generation rules - Saviynt Forums - 67847

Accountname Rule via advanced query - Saviynt Forums - 86141

How to write User Account Correlation Rule - SQL &... - Saviynt Forums - 34827

[RutujaM]

concat(8661,(substring(users.lastname,1,5),substring(users.firstname,1,1))

I have tried this.

[Raghu · Accepted solution]

@RutujaM  try below i tested as above example word designed below it working :

Firstname: Alexandra and Lastname: Hernandez

FirstName : A

LastName: herna

Account name should be: 8661hernaA

concat('8661',(substring(Lower(users.lastname),1,5)),substring(users.firstname,1,1))

[RutujaM]

I need first name's first character also small. eg. 8661hernaa

Can you modify a little?

[Manu269]

concat('8661',(substring(Lower(users.lastname),1,5)),substring(Lower(users.firstname,1,1)))

check this

[Raghu]

use below and try @RutujaM 

concat('8661',(substring(Lower(users.lastname),1,5)),substring(Lower(users.firstname),1,1))

[RutujaM]

This one is not working.

[Raghu · Accepted solution]

this one i tested it is working

concat('8661',(substring(Lower(users.lastname),1,5)),substring(Lower(users.firstname),1,1))

[Manu269]

@RutujaM  i tested in lab and it works.