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?
Go to Solution.
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 )
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.
Thanks for the responses. Below query worked
entitlement_valuekey in (select distinct eo.entitlement_valuekey from Entitlement_owners eo )