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

Need ARS requestable entitlement query

New Contributor II
New Contributor II

Hello Team , 

We have one requirement where we need to make configuration like User can only be able to raise request for entitlement B if he already has entitlement A how to do that. Can you provide some sample query for this.


Honored Contributor
Honored Contributor

@Diptansu_Sinha  For that you  need configure endpoint level access query:

Refrence query need change ent A value id

SELECT ev.DISPLAYNAME as ID FROM accounts a join user_accounts ua ON ua.accountkey = a.accountkey join users u ON u.userkey = ua.userkey join account_entitlements1 ae ON ae.accountkey = a.accountkey join entitlement_values ev ON ev.entitlement_valuekey = ae.entitlement_valuekey where ae.ENTITLEMENT_VALUEKEY = 1234 AND u.userkey = ${requestor}


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

Actually, we have requirement like if user have entA then he can be request for entB , if he has entC then only he can be able to request for entD 

You need to use dynamic attributes for this logic 

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