Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/22/2024 04:19 AM
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 ?
Solved! Go to Solution.
05/22/2024 03:04 PM
Hi @Rajatlm10 ,
As I understood your usecase -
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
05/23/2024 07:02 AM
05/23/2024 07:32 AM
Thank you so much for the detailed explanation. Its working fine.
I guess i was missing the FROM keyword from the query.
Thanx!