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

display only entêtement in ARS with at least one active owner

Antoine
Regular Contributor
Regular Contributor

Hello, 

We would like to display only entilements that have at least one active owner 

We used the config for requestable entitlement in ARS

We can check if an entitlement has a owner defined on it lke the query below

ev.id in (select distinct eo.entitlement_valuekey.id from Entitlement_owners eo)

When we try to cross the subquery  with a second table users like below

ev.id in (select distinct eo.entitlement_valuekey.id from Entitlement_owners eo,users usr where eo.userkey.id = us.userkey.id and usr.statuskey=1)

we have a "Invalid SQL syntax error" error

Antoine_0-1711617237629.png

Is it possible to have more than 1 table in that parameter  (in the subquery)?

if not how I can limit the list of entitlements to the entitlements that have at least one active owner ?

Regards

Antoine 

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Only entitlement_values table is exposed. 
use global configuration - Request 

rushikeshvartak_0-1711629649588.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.