Hello,
We have a use case where in we need to display the user's existing accounts (primary and privileged) for a particular application. We have a dynamic attribute in place to give us this information on the ARS page. When we run the query in Data Analyzer it works fine, but unable to pull the data as a drop down.
Queries tried:
1. select distinct a.name as ID from Users u, user_accounts ua , accounts a , endpoints ep where u.USERKEY=ua.userkey and ua.ACCOUNTKEY=a.ACCOUNTKEY and a.ENDPOINTKEY=ep.ENDPOINTKEY and ep.endpointkey=5 and u.userkey = ${requestor}
2.select distinct a.name as ID from Users u, user_accounts ua , accounts a , endpoints ep where u.USERKEY=ua.userkey and ua.ACCOUNTKEY=a.ACCOUNTKEY and a.ENDPOINTKEY=ep.ENDPOINTKEY and ep.endpointkey=1 and u.userkey = '1'
3.select distinct a.name from users u, user_accounts ua , accounts a , endpoints ep where u.USERKEY=ua.userkey and ua.ACCOUNTKEY=a.ACCOUNTKEY and a.ENDPOINTKEY=ep.ENDPOINTKEY and ep.endpointkey=5 and u.userkey = (Select userkey from users where userkey= ${requestor})
Please can you help on this?
Thanks in advance,
Uzair
