Hello,
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.
Most probably the issue was related to the fact that in the query we were comparing a string type with an integer because
role owner name = string
userid = integer
Below query works fine.
select
case when
'${access_request_cri_grole_owner_userId}' = '${access_request_cri_meu_userId}'
then 1
else 0
end
as Is_Requester_And_RO_Same
from dual