Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

dynamic attribute not working as intended

randhirsingh01
New Contributor
New Contributor

Hi all ,

I am trying to create a dynamic attribute, which displays only okta groups based on department. below is the query i have used in dynamic atrribute.

select distinct ev.customproperty7 as ID from entitlement_values ev, entitlement_types et, endpoints ep where ev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY and et.ENDPOINTKEY=ep.ENDPOINTKEY and ep.endpointname like 'Okta_randhir'

randhirsingh01_0-1724904664421.pngrandhirsingh01_1-1724904708676.png

 

randhirsingh01_2-1724904768539.png

 

5 REPLIES 5

stalluri
Valued Contributor II
Valued Contributor II

@randhirsingh01 
Places use this query in the dynamic attribute.
select distinct(customproperty7) as id from entitlement_values where entitlementtypekey = XXXXX

Entitlement type -->Config for Requestable Entitlement in ARS
ev.customproperty8 = '${ApplicationModule}'.    //ApplicationModule
this should be dynamicattribute name.

Screenshot 2024-08-29 at 12.30.27 AM.png





Best Regards,
Sam Talluri
If you find this a helpful response, kindly consider selecting Accept As Solution and clicking on the kudos button.

rushikeshvartak
All-Star
All-Star

Add query in default value section and also in dynamic attribute 

rushikeshvartak_0-1724907033053.png

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

NM
Honored Contributor III
Honored Contributor III

Hi @randhirsingh01 , add Mapping in action to be performed when parent attribute changes. And keep parent attribute empty


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

randhirsingh01
New Contributor
New Contributor

Hi All,

Thanks for the responses,

I have achieved the filtering of groups by "What action to perform when Parent attribute changes? - Refresh"' and configured other attribute to hide the department but when i keep the dynamic attribute as false it should display all groups which it is not displaying.

randhirsingh01_0-1724907909450.png

 

What is default value for checkboxes?


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.