Hi,
We have a use case where we have SaviyntForSaviynt custom Sav role such as
CPO Role:
ROLE_CPO_ASIA
ROLE_CPO_AFRICA
ROLE_CPO_EUROPE
RPO Role:(Each CPO role should have minimum of 3RPO role)
ROLE_RPO_INDIA
ROLE_RPO_BHUTAN
ROLE_RPO_SRILANKA
ROLE_RPO_SOUTHAFRICA
ROLE_RPO_GHANA
ROLE_RPO_SOMALIA
ROLE_RPO_FRANCE
ROLE_RPO_RUSSIA
ROLE_RPO_SPAIN
If you have CPO role then you will be able to request all of the CPO and RPO role itself(Which is ROLE_CPO% and ROLE_RPO%)
However,If you have RPO Role then you will able to request the entitlement of RPO role only.(Which is ROLE_RPO%)
I have tried to query down the Config for Requestable Entitlement in ARS in endpoint section but I am not able to get the desired outcome.
The Query:
Note:
In the Entitlement of RPO I have hardcoded the value of 'RPO' in customproperty3 and 'CPO' in customproperty4
Where as in the CPO entitlement only I have hardcoded the value of'CPO'in customproperty
SELECT ev.entitlement_value
FROM entitlement_values ev
WHERE ev.customproperty4='CPO' AND ev.customproperty4 IN (
SELECT ea.customproperty4
FROM entitlement_values ea
WHERE ea.entitlement_value IN (
SELECT ed.entitlement_value
FROM entitlement_values ed
WHERE ed.entitlement_valuekey IN (
SELECT ael.entitlement_valuekey
FROM account_entitlements1 ael
WHERE ael.accountkey IN (
SELECT ua.accountkey
FROM user_accounts ua
WHERE ua.userkey IN (
SELECT userkey
FROM Users
WHERE userkey in (select userkey from Users where userkey in (${requestor}))
)
)
)
)
) AND (ev.customproperty3='RPO' and ev.customproperty3 IN (
SELECT ea.customproperty3
FROM entitlement_values ea
WHERE ea.entitlement_value IN (
SELECT ed.entitlement_value
FROM entitlement_values ed
WHERE ed.entitlement_valuekey IN (
SELECT ael.entitlement_valuekey
FROM account_entitlements1 ael
WHERE ael.accountkey IN (
SELECT ua.accountkey
FROM user_accounts ua
WHERE ua.userkey IN (select userkey from Users where userkey in (${requestor}))
)
)
)
))
Please let me know where Iogic I am missing here.
Thank you
