Need ARS requestable entitlement query

[Diptansu_Sinha]

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.

[Raghu]

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

https://forums.saviynt.com/t5/application-access-governance/application-roles-request-query-based-on...

[Diptansu_Sinha]

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 

[rushikeshvartak]

You need to use dynamic attributes for this logic