Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/24/2024 12:58 AM
Hello everybody,
I have the following challange right now:
An endpoint should be requestable, but only visible to a couple of users.
This is already done via Access Query of the endpoint.
For example:
"Where users.customproperty20='Manager'"
So now only Manager are able to see the tile and to request.
But the problem now is, if a manager wants to request for another employee, and this employee has not the value "Manager" filled in customproperty20, the endpoint/tile is not visible in ARS and consequently not requestable.
Is there a way, that the tile is only visible for managers, but the managers can request for every employee?
Best regards
Sergius
07/24/2024 01:31 AM
@Sergius ,
Try below query in your Access Query:
Where users.customproperty20='Manager' or users.manager in (select userkey from users where customproperty20='Manager')
07/24/2024 08:10 PM
Who is manager of another employee ? Is it requestor ?
07/24/2024 10:46 PM
@Sergius may be u will achive based on below quey
WHERE users.customproperty20 = 'Manager' OR users.manager IN (SELECT userkey FROM users WHERE customproperty20 = 'Manager')