We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Not show entitlements without owner in ARS

AmitM
Regular Contributor III
Regular Contributor III

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 )

AmitM_0-1687354891841.png

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

4 REPLIES 4

naveenss
All-Star
All-Star

can you try the below:

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

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

AmitM
Regular Contributor III
Regular Contributor III

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

dgandhi
All-Star
All-Star

Have you tried below OOTB configuration for this requirement?

dgandhi_0-1687356792973.png

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

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

AmitM
Regular Contributor III
Regular Contributor III

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