Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Not show entitlements without owner in ARS

AmitM
Valued Contributor
Valued Contributor

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
Valued Contributor
Valued Contributor

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
Valued Contributor
Valued Contributor

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