AnsweredAssumed Answered

Request Form filter entitlements based on query from custom table

Question asked by shakti nayak on Jun 21, 2019
Latest reply on Jun 21, 2019 by Mostafa Helmy

We have a custom table created in the aveksa database.

the purpose is to use the table in the entitlement filter in request forms. but the query is not working for the custom table.

 

"x."Business Source Name"='ABC'
and x."Entitlement Name" in ('AC-SERVICES-CHECKER')"  ------------- This works fine

 

but

 

x."Business Source Name"='ABC'
and x."Entitlement Name" in (select role from custom_table where department = 'HR') ----- This doesn't work

and the entitlement field doesn't fetch any value.

 

custom_table contains 2 columns role and department.

select role from custom_table where department = 'HR' returns "AC-SERVICES-CHECKER" when run in db.

 

Any suggestions how to filter data based on a custom created table in AVUSER schema.

Outcomes