Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/27/2023 01:55 AM
Hi,
In the entitlement owner campaign I want that when the certifier selects consult he is displayed only with the user's manager name in the list.
For eg: I am the certifier, I should not be able to certify my own account. When I select consult I should be given only my manager in the list. Also, when I select Consult for user "Abc", I should be displayed only ABC's manager in the list.
Will that be possible via Consult Query? If yes, Please help me with the query.
Thanks
Nidhi
Solved! Go to Solution.
06/28/2023 03:34 AM
Consult query does not support filter on the basis of certification user item or certifier.
06/28/2023 11:21 AM
Have you tried below option?
Example 1 (To display Managers) : The following query can be used to display the Managers of the logged-in user upon using Consult action.
select u from Users u where 1=1 and u.id in (select manager from Users where id=:loggedInUser)
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.