AccounID attribute in Access request Form

[jugourta]

 

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.]

[naveenss]

Hi @jugourta  create a dynamic attribute and populate the accountID using SQL query and use it in your other query.

[jugourta]

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 )

[rushikeshvartak]

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};