Auto populate the department and company name from manager account

[Ratna]

Hi Team,

In the user creation form, we are trying to auto populate the values of department and company name from manager account. 

Requestor should be Manager by default and it should be editable, Based on the value of manager field the department and company name attributes must be auto populate,

When we change the manager name, the attributes still showing the same old values of requestor. 

Queries we are using currently

Manager:

Values
select distinct username as ID from users

Default Values
select username as ID from Users where userkey = ${requestor}

Company:

Default Values
select COMPANYNAME as ID from Users where userkey = ${requestor}

Department: 

Default Values
select DEPARTMENTNAME as ID from Users where userkey = ${requestor}

Please suggest us what changes can we make to fulfill our request.

Thank you.

[NM]

Hi @Ratna , what do you mean by changing manager is it a field in form or you make the change in user profile?

[Ratna]

Hi NM,

We are changing it in user creation form.

Changing manager name in the sense that,  In some cases, there might be a chance that, we change it to some other person before user submitting the creation form. Even though, it is taking the value 'requestor', by default.

[NM]

Hi @Ratna yes it will as you have use requestor binding variable.

If requestor is the new manager it will pick data from his/her peofile

[Ratna]

Hi @NM ,

Will it be possible to auto populate the values of department and company name from manager account. irrespective of  manager value either requestor or someone else (who is not the requestor)?

[NM]

Yes.. but only thing is whose manager are you trying to get .. as you are trying to create a new user profile.

[PremMahadikar · Accepted solution]

Hi @Ratna ,

By your above use case, you have a parent dynamic attribute name 'manager'. 

Department and Company are two child dynamic attributes.

Change you need to do?

1. Make sure you have configured, Refresh or Mapping under 'What action to perform when Parent attribute changes?' configuration under parent attribute (i.e. Manager in your case)

2. Company: Default Values
   select COMPANYNAME as ID from Users where username= ${Manager} (Here Manager is dynamic attribute name)

3. Department: Default Values
   select DEPARTMENTNAME as ID from Users where username= ${Manager} (Here Manager is dynamic attribute name)

4. If for 2 and 3 DA, parent attribute is not configured, do add this below configuration. (Here Manager is dynamic attribute name which would consider here as parent)

If this helps, please consider selecting Accept As Solution and hit Kudos

[Ratna]

Hi @PremMahadikar 

Thank you for the solution. It worked perfectly.

Ratna.

[rushikeshvartak]

• Use below queries
  • Manager:
    • Values
      select distinct username as ID from users where statuskey=1
    • Default Values
      select username as ID from Users where userkey = ${requestor}
• Company:
  • Values
    select COMPANYNAME as ID from Users where userkey = ${DA_Manager}
  • Default Values
    select COMPANYNAME as ID from Users where userkey = ${requestor}
  • 
  •  
• Department: 
  • Values
    select COMPANYNAME as ID from Users where userkey = ${DA_Manager}
  • Default Values
    select DEPARTMENTNAME as ID from Users where userkey = ${requestor}
  • 

Use above Queries and add Mapp