Not show entitlements without owner in ARS

[Amit_Malik]

Hi Team , the requirement is to not show / make entitlement requestable if it doesn't have an owner.

I tried below queries in Config for Requestable Entitlement in ARS: None works

ev.entitlement_value like '%A4123%' and ev.entitlement_valuekey in (select distinct eo.entitlement_valuekey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo)

ev.entitlement_value like '%A4123%' and ev.entitlement_valuekey in (select distinct eo.entitlement_valuekey from Entitlement_owners eo )

This alone works : ev.entitlement_value like '%A4123%' 

And if I only use ev. and conditions it works but not if I use any other table

[naveenss · Accepted solution]

can you try the below:

ev.entitlement_value like '%A4123%' and ev.id in (select distinct eo.entitlement_valuekey.id from Entitlement_owners eo)

[Amit_Malik]

Yeah that works. I should have tried this. My Brain Fade (S S) moment. 

[dgandhi · Accepted solution]

Have you tried below OOTB configuration for this requirement?

https://docs.saviyntcloud.com/bundle/EIC-Admin-v2020x/page/Content/Chapter06-EIC-Configurations/Conf...

[Amit_Malik]

Yeah that works as well. And a better solution to go for. Thanks.