10/20/2022 02:27 AM
During Entitlement Owner Certification, I want to exclude those entitlements that does not have owners.
How can I achieve this, if this can be achievable through advance query.
Can I get the sample query?
Solved! Go to Solution.
10/25/2022 01:35 PM - edited 10/26/2022 12:04 AM
Try below query in Entitlements Query to filter out entitlement with owner are selected
ev.entitlement_valuekey in (select distinct eo.entitlement_valuekey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo )
10/25/2022 10:26 PM
Can you please try by selecting Select Certifier option as Select From Manual Query.
This feature checks and validates the manual query (with alias and without alias) and displays the validation messages, appropriately before creating a campaign.
11/23/2022 08:30 AM
Thanks for the responses. Below query worked
entitlement_valuekey in (select distinct eo.entitlement_valuekey from Entitlement_owners eo )