Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Advanced query Account name rule

RutujaM
New Contributor II
New Contributor II

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

9 REPLIES 9

Manu269
All-Star
All-Star

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

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

RutujaM
New Contributor II
New Contributor II

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

I have tried this.

Raghu
Honored Contributor
Honored Contributor

@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))


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

RutujaM
New Contributor II
New Contributor II

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

Can you modify a little?

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

check this

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Raghu
Honored Contributor
Honored Contributor

use below and try @RutujaM 

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


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

RutujaM
New Contributor II
New Contributor II

This one is not working.

Raghu
Honored Contributor
Honored Contributor

this one i tested it is working

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


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

@RutujaM  i tested in lab and it works.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.