Autopopulate Firstname and Lastname based on Username

[Ratna]

Hi

We are trying to autopopulate the attributes "First name of selected username" and "Last name of selected username"  based on Username in Rehire Senario. How can i implement the query.

[Raghu]

@Ratna 

SQL ENUM use below :

select distinct concat(u1.firstname," ",u1.lastname) as ID from users u1 where u1.userkey=${requestee}

[Ratna]

@Raghu 

I am trying to autopopulate firstname attribute from username attribute. Used the below query, not able to fetch anything.

This is on Rehire senario, when we get any rehire request, we will search the user name.. if that exists, automatically firstname and lastname attributes should autopopulate, just to confirm the user is same or not.

"Select firstname as ID from users where userkey = ${requestee}"

[Raghu · Accepted solution]

DA 1 Name.Username(Only for rehire..)

Lable Name:Username

DA2: Firstname

SQL:

Value :Select firstname as ID from users where username= ${DA1 Name}

Default : Select firstname as ID from users where username= ${DA1 Name}

Parent Attribute :DA1 NAMe

Editable On Update : check

What action to perform when Parent attribute changes? Mapping

still issue share ss

https://forums.saviynt.com/t5/saviynt-knowledge-base/configuring-create-register-user-form-in-eic/ta...

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/create-user-form-child-attribute-is-not-auto-popul...