How to hide dynamic attribute

[Vidhya]

Hi Team,

We have a dataset with three columns description,departmentcode and ou path. We have created three different dynamic attributes in identity lifecycle :

Following are the queries for each dynamic attribute:

For description : select distinct attribute2 as id from dataset_values where dataset_values.datasetname ='COB_DEPARTMENT_NAME_NONEMPLOYEE1'

For departmentcode : select ATTRIBUTE1 as ID from dataset_values where dataset_values.datasetname ='COB_DEPARTMENT_NAME_NONEMPLOYEE1' and ATTRIBUTE2=${dyndepartment}

For ou : select ATTRIBUTE3 as ID from dataset_values where dataset_values.datasetname ='COB_DEPARTMENT_NAME_NONEMPLOYEE1' and ATTRIBUTE1 = ${dyndepartmentcode}

So when departmentname is selected then departmentcode is populated when you select departmentcode the ou will be populated 

But I want to hide ou dynamic attribute . It should not be visible in UI form .

Can anyone help me on achieving this?

Thanks,

Vidhya

[PremMahadikar]

Hi @Vidhya ,

There are two options:

1. Create another mandatory dynamic attribute like Confirm?Enum Value: Yes/No or Submit?Enum Value: Yes/No
   • Based on the above, one department select, user needs to select this dynamic attribute
   • In this DA, Action: SHOW###departmentcode###Yes___HIDE###departmentcode###No___SHOW###confirm2###Yes___HIDE###confirm2###No___
2. Use NONE as value.
   
   • Refer this solution article: Solved: HIDE/SHOW dynamic attributes in ARS form - Saviynt Forums - 63699
   • Define all the values from department Ex: SHOW###departmentcode###department1___SHOW###departmentcode###department2___SHOW###departmentcode###department3___SHOW###departmentcode###departmentN___HIDE###departmentcode###NONE___
   • Similar for departmentvalue DA for SHOW/HIDE ou

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

[rushikeshvartak]

Use Action String

[Vidhya]

Hi,

Thanks. One more question:

We have this option only for create user form don't we have it for update user form? I want few attributes during update to be stored in user column when hidden 

Thanks,

Vidhya

[rushikeshvartak]

That configs available under dynamic attributes config 

• above config is used to use hidden attributes in workflow 

[Vidhya]

Hi @rushikeshvartak ,

If I check hide on update the value will not be stored in user column. Here in user update form when I select department , department code is not populated instead user needs to select from dropdown but according to query it shows proper dept code in dropdown but I wanted it to populate in field without need to select it from dropdown.

Thanks,

Vidhya

[rushikeshvartak]

Add same query in default value

[Vidhya]

Hi @rushikeshvartak ,

I did. The same query is in default value. And in user update form it fetches the proper department code but shows in dropdown only problem is I need to select it (above picture). I wanted it to populate in field automatically.

[rushikeshvartak]

Please provide configs Screenshot for parent and child DA

[Vidhya]

Hi @rushikeshvartak ,

dyndepartment is parent attribute

Values: select distinct attribute2 as id from dataset_values where dataset_values.datasetname ='COB_DEPARTMENT_NAME_NONEMPLOYEE1' 

dyndepartmentcode is child attribute

Values: select ATTRIBUTE1 as ID from dataset_values where dataset_values.datasetname ='COB_DEPARTMENT_NAME_NONEMPLOYEE1' and ATTRIBUTE2=${dyndepartment}

default values: select distinct ATTRIBUTE1 as ID from dataset_values where dataset_values.datasetname ='COB_DEPARTMENT_NAME_NONEMPLOYEE1' and ATTRIBUTE2=${dyndepartment}

Thanks,

Vidhya

[rushikeshvartak]

Instead of Mapping keyword use Refresh

[Vidhya]

Hi @rushikeshvartak ,

I tried with Refresh keyword till in update user form when department is changed the department code is not autopopulated. Instead, the value is shown in dropdown where you need to select 

Thanks,

Vidhya