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