We need to have a custom logic in our Request WFs (associated to role related changes) such that;
if Change Requester is different than Role Owner, some actions will be taken, Otherwise, some other actions will be taken.
Therefore, we put an SQL Select node with the below displayed query.
When we perform any change on role (add entitlement to role), the request is hung on the Select Node. What could be the reason?
As an additional info, related CR stays in Open Status.