and more in a single search tool across platforms. Read the announcement here. |
04/06/2023 01:38 PM
Hi Team,
In the Elevated Account Approval workflow, a custom query is used to send an approval request to a usergroup for 2nd level approval after the user's supervisor approves at the first level. This works as expected if one FFID/System is selected in the request. However, if multiple IDs or Systems are selected in one request, after the supervisor approves, the request is not being sent to the correct 2nd level approver(s). Instead it seems to be sending approval to the default approver set at the global config level.
Custom Query:
Select Userkey From Usergroup_users Where FIND_IN_SET(Usergroup_users.User_groupkey,(Select Ownerusergroupkey From Accountowners Where Accountkey = (Select Raa.Attribute_value
From Request_access_attrs Raa , Ars_requests Ar, Request_access Ra WHERE Ar.REQUESTKEY = Ra.REQUESTKEY And
Ra.REQUEST_ACCESSKEY = Raa.REQUEST_ACCESS_KEY And Ar.Requestkey=${ARSREQUEST.Id}) And Ownerusergroupkey != 0 And Rank = 1))
Union
Select Owneruserkey As Userkey From Accountowners Where Accountkey = (Select Raa.Attribute_value
From Request_access_attrs Raa , Ars_requests Ar, Request_access Ra WHERE Ar.REQUESTKEY = Ra.REQUESTKEY And
Ra.REQUEST_ACCESSKEY = Raa.REQUEST_ACCESS_KEY And Ar.Requestkey=${ARSREQUEST.Id}) And Owneruserkey != 0 And Rank = 1
The above SQL statement is devided into 2 parts.
1. The first part which is above the ‘union’ is used to get the userkeys of the FFID account owner group.FFID request first assigned to supervisor of beneficiary.
2. The second part which is below the ‘union’ is used to get the userkeys of the FFID account owner.After level 1 approver, FFID account owner supervisor approval required.
Expected behaviour - Enduser try to submit the request for multiple ID's or Systems in one request,
When user submits request for multiple ID's or Systems in one request then according to custom query it goes for manager and owner group approval. After Level 1 Approver, only the account owner will approve the ID request of the same system for which ID request has come.
Observed Behaviour -
Level 1 approval is working properly. There is a problem in level 2 approval, normally the owner of the account with rank1 from whom the ID request has come can only approve. In this case, Any account owner who has rank 1 is able to approve the request of any account ID request.
Who is going to benefit from this idea? Enduser,Manager
What is the priority from your standpoint? High
Regards,
Satyam
04/10/2023 04:53 PM
Hi @ssingh16
Are you using a parallel or a serial workflow?
If you are using serial, then you may want to consider switching to a parallel workflow. If the request is expected to be routed to different user groups for different FFIDs in a single request, then a serial workflow will not be able to handle this, it will not be able to split the request route into two paths.
04/13/2023 08:04 AM
no, we are using parallel workflow type.
04/25/2023 03:00 PM
Hello @ssingh16
We are currently reviewing this and will provide you with an update as soon as possible.
Can you export and attach your workflow here, please?