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.
