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.
Were there any messages in the logs? Most of the time when this happens the workflow engine is actually having issues on the next node or following node and has rolled back to the last "good" state... Which makes it seem to be an issue with the SQLSelect node..
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
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