Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/12/2024 06:37 AM - last edited on 04/14/2024 11:00 PM by Sunil
in the update Account case We need to use Account ID value that displayed in ARS for to filter Team attribute value and we need to get the Plant values contain in customproperty 1 in the account and to use it in the sql request like this example :
select distinct customproperty3 as 'ID'
from entitlement_values
where ENTITLEMENTTYPEKEY
in (
select entitlementtypekey
from entitlement_types
where endpointkey
in (
select endpointkey
from endpoints
where endpointname='APP_Name' ) and entitlementname='Team' ) and entitlement_values.status = 1
and customproperty2 in( select distinct customproperty1 from accounts where accountID =${accountID})
but i don't know what is the correct syntax to use.
can you help me ?
[This post has been edited by a Moderator to remove sensitive information.]
04/12/2024 07:05 AM
Hi @jugourta create a dynamic attribute and populate the accountID using SQL query and use it in your other query.
04/12/2024 08:26 AM
thnks for answer, we don't can use a dynamic attribute because the Team attribute type is SQL MULTISELECT and if we use this solution we have some issue in the update Account step (In access request form the multivalues are not displayed )
04/12/2024 08:24 PM
SELECT DISTINCT ev.customproperty3 AS 'ID'
FROM entitlement_values ev
JOIN entitlement_types et ON ev.ENTITLEMENTTYPEKEY = et.ENTITLEMENTTYPEKEY
JOIN endpoints ep ON et.endpointkey = ep.endpointkey
JOIN accounts a ON ev.customproperty2 = a.customproperty1
WHERE ep.endpointname = 'APP_Name'
AND et.entitlementname = 'Team'
AND ev.status = 1
AND a.accountkey= ${accounts};