Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/13/2024 09:26 PM
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.
Could someone help us to resolve this issue.
Regards,
Bhargavi Padaraju.
Solved! Go to Solution.
06/13/2024 09:38 PM
select entitlementid as id from entitlement_values where ENTITLEMENTTYPEKEY=405
also select editable checkbox
06/14/2024 01:47 AM
@Bhargavi3 try below query
select entitlementid as ID from entitlement_values where ENTITLEMENTTYPEKEY in (405)
06/14/2024 02:32 AM
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
06/17/2024 03:27 AM
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.
06/17/2024 04:17 AM
@Bhargavi3 Great. Mark the solution and close the thread.