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

ARS Dynamic Attributes

jezzanuena
Regular Contributor
Regular Contributor

Im trying to get the current entitlement of the account and display it in the ARS Form. But Im not getting any results. Here is my query.

select ev.displayname as ID from accounts a inner join user_accounts ua ON ua.accountkey=a.accountkey inner join Users u ON u.userkey=ua.userkey inner join account_entitlements1 ae ON ae.accountkey=a.accountkey inner join entitlement_values ev ON ev.entitlement_valuekey=ae.entitlement_valuekey inner join entitlement_types et on et.entitlementtypekey=ev.entitlementtypekey inner join endpoints ed on ed.endpointkey=et.endpointkey where ed.endpointkey = 211 and u.userkey = XXXX

I used all the following attributes here but nothing worked.

${loggedInUser.id}
${requestee.id}
${requestor.id}
${u.userid}
${u.username}
${u.userkey}
${a.accountkey}

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

select ev.displayname as ID from accounts a inner join user_accounts ua ON ua.accountkey=a.accountkey inner join Users u ON u.userkey=ua.userkey inner join account_entitlements1 ae ON ae.accountkey=a.accountkey inner join entitlement_values ev ON ev.entitlement_valuekey=ae.entitlement_valuekey inner join entitlement_types et on et.entitlementtypekey=ev.entitlementtypekey inner join endpoints ed on ed.endpointkey=et.endpointkey where ed.endpointkey = 211 and u.userkey = ${requestee}


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

PremMahadikar
Valued Contributor
Valued Contributor

Hi @jezzanuena ,

Another option:

select ev.displayname as ID from accounts a inner join user_accounts ua ON ua.accountkey=a.accountkey inner join Users u ON u.userkey=ua.userkey inner join account_entitlements1 ae ON ae.accountkey=a.accountkey inner join entitlement_values ev ON ev.entitlement_valuekey=ae.entitlement_valuekey inner join entitlement_types et on et.entitlementtypekey=ev.entitlementtypekey inner join endpoints ed on ed.endpointkey=et.endpointkey where ed.endpointkey=211 and u.userkey=${user.id}

 

If this helps your solution, please consider selecting Accept As Solution and hit Kudos

Raghu
Honored Contributor
Honored Contributor

@jezzanuena  try below

select ev.displayname as ID from accounts a inner join user_accounts ua ON ua.accountkey=a.accountkey inner join Users u ON u.userkey=ua.userkey inner join account_entitlements1 ae ON ae.accountkey=a.accountkey inner join entitlement_values ev ON ev.entitlement_valuekey=ae.entitlement_valuekey inner join entitlement_types et on et.entitlementtypekey=ev.entitlementtypekey inner join endpoints ed on ed.endpointkey=et.endpointkey where ed.endpointkey = 211 and u.userkey in ( ${requestee})


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