Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/18/2024 12:04 AM
Hi Team,
We have a requirement related to the workflow for access and account requests, as detailed below:
Requirement: When a user requests an account or access, the precondition is that the manager's manager is on leave. request should go to the manager.
request should first go to the user's manager for approval. After the manager's approval, next assign to the application owner. Following this step, it will go to the application owner for final approval.
However, there is a specific condition to handle:
1. If the manager's manager is on leave (indicated by a leave status of 1), the request should be routed to the manager.
2. Note that in this scenario, the manager is not setting any "Do Not Disturb Delegate" or "Delegate User" for his absence.
We need a condition in the workflow that can check the leave status of the manager's manager and redirect the approval task accordingly.
Please let me know the possible solutions or approaches to implement this workflow requirement.
09/18/2024 05:21 AM
Sample
SELECT u3.userkey
FROM users AS u1
JOIN users AS u2 ON u1.manager = u2.userkey
JOIN users AS u3 ON u2.manager = u3.userkey
WHERE u1.username = '${users.username}'
09/23/2024 03:42 AM
if else condition to check user manager's manager's leave status
09/23/2024 08:38 AM
You can add condition to sample query provided