Entitlement Owner campaign - Consult User Query

[Community_User]

Originally posted on November 28 2019 at 15:57 UTC

Most of our entitlements have 1 Rank1 owner and 1 to several Rank 2 owners. In an Entitlement Owner campaign, we would send the campaign only to Rank 1 owner.

However, in some cases (specifically “own access”), we would want to consult Rank 2 owners. Therefore we would need to define the Consult User Query to retrieve Rank 2 owners of the current entitlement being reviewed.

While the "Consult User Query" allows to create a SQL Select statement to select the users we can consult, there is nothing in the documentation explaining which context parameters we could use (ex: entitlement we want to consult for, current reviewer, etc).

Any details on what is available and possible?

[Community_User · Accepted solution]

Originally posted on November 29 2019 at 09:07 UTC

Hi Fabrice, we are working on the consult query functionality to enable the consult pop up to display rank 2 entitlement owners by using the below consult query. Currently its in testing phase and it will be available soon.

"select u from Users u where 1=1 and u.id in (select eo.userkey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo where eo.rank=2).

[Community_User]

Originally posted on January 16 2020 at 18:39 UTC

Hi Brian,

Have you been able to make this work? Is the above stated query the final version? Does it shows only Rank 2 owners of the given entitlement?

Fabrice