dynamic Attribute.

[Rajatlm10]

Hi , 

we have a requirement that if user select a country in DA "country" then corresponding country code value should pop up in the other DA "countrycodes" which will be not editable. 

Also country is a single select and countrycodes can be multi select. like for a single country there can be multi country codes selected. 

for exp:

when user selects country as united states then countrycodes should show as US-001. 

when user select country as Albania then countrycodes should show as AL-008.

i am using the below query to achieve the same but its not working. 

select id case when ${Country}='united states' Then 'US-001' when ${Country}='Albania' Then 'AL-008' END as id

Has anyone worked on something like that ?

[PremMahadikar · Accepted solution]

Hi @Rajatlm10 ,

As I understood your usecase -

1. If user select a country in DA "country" then corresponding country code value should pop up in the other DA "countrycodes" which will be not editable. 
   • The above is achievable
2. Also country is a single select and countrycodes can be multi select. like for a single country there can be multi country codes selected. 
   • Using select case statements selecting single country wouldn't pop-up multi select country code. Because case statement once executed wouldn't check for next one.
   • To achieve this, upload country and country code mapping in to datasets and pull that inside dynamic attribute. Here multi select works as you not using case inside select.
3. The query you mentioned is wrong (select id), use below

select case when ${country}='United States' then 'US-001' when ${country}='Albania' then 'AL-008' end as id from dual

The dynamic attributes looks like below:

1. Parent Attribute: Country

Attribute Name	country
Attribute Type	Single Select From SQL Query
Required	Check
Editable	Check
What action to perform when Parent attribute changes?	Mapping

2. Child Attribute: Country Code

Attribute Name	countrycode
Attribute Type	Single Select From SQL Query
Value	select case when ${country}='United States' then 'US-001' when ${country}='Albania' then 'AL-008' end as id from dual
Default Value	select case when ${country}='United States' then 'US-001' when ${country}='Albania' then 'AL-008' end as id from dual
Parent Attribute	country

Refer the links below to use dataset in your queries:

https://forums.saviynt.com/t5/identity-governance/multi-select-in-dynamic-attribute/m-p/90910

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

[PremMahadikar]

@Rajatlm10 ,

Did the above solution work?

[Rajatlm10]

@PremMahadikar 

Thank you so much for the detailed explanation. Its working fine. 

I guess i was missing the FROM keyword from the query. 

Thanx!