Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
01/09/2024 03:37 AM
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.
01/09/2024 08:51 PM
Can you check logs what query is executed