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

Sav Role - Whom to request query

prachi
Regular Contributor II
Regular Contributor II

Hi,

We have a requirement to create a SAV ROLE where the requestor can raise the request for users belong form the same organization.

I have used the option advance query in "WHOM TO REQUEST" in SAV role and used query :
select a from Users a where a.customer = '${users.customer}'

Also tried :

select a from Users a where a.customer= (select c.id from Customer c where c.customername='${users.customer}')

None of the two queries are working.

Any suggestion/inputs to achieve the requirement would be helpful.

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Can you check logs what query is executed 


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