Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Unable to see dynamic attribute list on ARS page with simple query

Bhargavi3
New Contributor III
New Contributor III

Hi Team,

Our requirement is to pass role code(Entitlement ID) through create account json. So, we are creating a dynamic attribute where we can see all the list of role codes where user can select one and that dynamic attribute will be mapped with the attribute in Create Account json. The below query we are using to fetch the data, it is working in data analyzer but it is not getting reflected in ARS page.

select entitlementid from entitlement_values where ENTITLEMENTTYPEKEY=405 

we have 108 entitlements where user should select one.

 

Bhargavi3_0-1718339105434.png

Could someone help us to resolve this issue.

Regards,

Bhargavi Padaraju.

5 REPLIES 5

rushikeshvartak
All-Star
All-Star

select entitlementid  as id from entitlement_values where ENTITLEMENTTYPEKEY=405 

also select editable checkbox


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Raghu
All-Star
All-Star

@Bhargavi3  try below query

select entitlementid as ID from entitlement_values where ENTITLEMENTTYPEKEY in (405)


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

pmahalle
All-Star
All-Star

Hi @Bhargavi3 Update the query as below and check the editable check box in your dynamic attribute check once. In case your entitlementid is not readable you use second query to show both entitlementid as well as entitlement_value in your dropdown

1. select entitlementid as id from entitlement_values where ENTITLEMENTTYPEKEY=405 

2. select entitlementid as id, entitlement_value as inlinedescription from entitlement_values where ENTITLEMENTTYPEKEY=405 


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂

Bhargavi3
New Contributor III
New Contributor III

Thanks for all your replies.
It is working now. We have used distinct key and it worked.

select distinct entitlementid from entitlement_values where ENTITLEMENTTYPEKEY=405;

Thanks,

Bhargavi Padaraju.

@Bhargavi3  Great. Mark the solution and close the thread.


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂