and more in a single search tool across platforms. Read the announcement here. |
10/25/2022 11:00 AM
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
Solved! Go to Solution.
10/25/2022 11:41 AM
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.
10/25/2022 01:28 PM
Saviynt Version 5.5 SP5
This is working 5.5 SP5
Campaign
Rank 3 Users
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)
10/25/2022 10:29 PM
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>);
11/02/2022 12:30 PM
Thank you all for your great feedback. It is working as per your suggestion.