Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Campaign Config - Consult User Query to populate entitlement owners rank x

Miko
New Contributor III
New Contributor III

Hello,

We want certifier to consult from rank 3 entitlement owners. We tried both below queries and they don't  return any during certification

select u from Users u where 1=1 and u.id in (select distinct eo.userkey from Entitlement_owners eo where eo.rank=3)

 

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

Please advise how to populate rank 3 entitlement owners during campaign consult.

Thanks

4 REPLIES 4

avinashchhetri
Saviynt Employee
Saviynt Employee

@Miko,

I'm assuming this is an Entitlement Owner Certification, I tried the query you have shared and works fine for me. However it was done in v2021.

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

Here are the details.

avinashchhetri_0-1666723127570.png

 

 

 

Regards,
Avinash Chhetri

rushikeshvartak
All-Star
All-Star

Saviynt Version 5.5 SP5

This is working 5.5 SP5 

rushikeshvartak_5-1666729690104.png

 

 

Campaign 

rushikeshvartak_0-1666728945166.png

rushikeshvartak_1-1666728979835.png

rushikeshvartak_4-1666729641377.png

 

Rank 3 Users

rushikeshvartak_3-1666729581452.png

 

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

 

 


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

Manu269
All-Star
All-Star

Hi,

Validated the same in saviynt v5.5SP3.11/3.10 using below query and works perfectly :

SELECT u
FROM   users u
WHERE  1=1
AND    u.id IN
                (
                SELECT DISTINCT eo.userkey
                FROM            com.saviynt.ecm.identitywarehouse.domain.entitlement_owners eo
                WHERE           eo.rank=<ADD the rank here>);

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Miko
New Contributor III
New Contributor III

Thank you all for your great feedback. It is working as per your suggestion.