Workflow approver assigne not populating based on usergroup and its going Admin

[CR]

Hi Team,

We have requirement Enable request for 4 level approval , as of  New account/Modify account request have 4 level approval and its working as expected also.

similar way we implemented 4 level approval but 2 and 3 level based application name and user group through approval will assignee ,but it going default Admin user. verified User group users also active

Below query we are using  in workflow :

select userkey from user_groups ug join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY and user_groupname=concat(replace('${Application}', ' ', '_'), '-HA')

Example : Appraisal_Scope_Platform-HA

Logs :

2024-02-01T19:04:32+05:30-arsms-c.s.s.a.controller.RequestController-http-nio-8787-exec-6-DEBUG-Response:: {enableBulkApproval=true, showActions=true, allowChangingApprover=true, noRecords=false, requests=[{requestedFor=AbiramaSundhari Ramanathan (917574), processInstanceID=MADL_AddAccessRequestWF_Final_V2_parallel.9022542, endpoints=Vector, accessApproversPk=17902, requestType=Enable Account, requestKey=4677, requestDetails=Vector - RABIRAMAOVC1I4TG Attributes-ACCOUNTKEY:5366376, requestOrigin=UI, dueDate=2024-02-02 13:29:27.0, platformType=null, requestor=KammariRaghu Chary (931813), reqId=9022542, requestDate=2024-02-01 13:29:27.0, processInstanceidNew=MADL_AddAccessRequestWF_Final_V2_parallel.9022542, jbpmActivityName=Product Owner Approval -standard, assignee=[Administrative User (admin)], businessJustification=null, accessApproversKey=[1], status=REQUEST.ACCESS.STATUS.OPEN}], message=Successful, enablePopOver=false, bulkApprovalCommentsFlag=false, defaultRowCount=20, allowAcceptReject=false, allowModifyRequest=true, requestRejectCommentsMandatory=false, requestAcceptCommentsMandatory=false}

Please someone help on subjected issue.

Note : if we pass direct owner and User Group name it working as expected , our scenario should work dynamically application name will take.

[rushikeshvartak]

dynamicAttributes.get('Application')

Share logs once you raise request

[CR]

Thanks for response ..!

Please find logs.

Request Id :9023338

[rushikeshvartak]

Enable account does not have any dynamic attributes hence it won't work. Are you storing Application on account level customproperty ?

[CR]

Yes @rushikeshvartak ,

We are saving Account level cp12 column through dynamic atrribute application name but without User Group call dynamic application owners pick?

Thanks,

Raghu

[rushikeshvartak]

select userkey from user_groups ug join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY and user_groupname in (select a.customproperty1 from request_Access ra,accounts a where a.accountkey=ra.accesskey and ra.requestkey=${ARSREQUEST.id})

[CR]

Thanks for query and quick response.

We have filter user group need append '_' and 'HA' . we are following all application same format and it taking dynamically from user group , above not work via user group owner .

select userkey from user_groups ug join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY and user_groupname=concat(replace('${Application}', ' ', '_'), '-HA')

can you give query for same format please

[rushikeshvartak]

select userkey from user_groups ug join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY and user_groupname in (select concat(replace(a.customproperty1, ' ', '_'), '-HA') from request_Access ra,accounts a where a.accountkey=ra.accesskey and ra.requestkey=${ARSREQUEST.id})

[CR]

@rushikeshvartak  will check and confirm.

Thanks,

Raghu

[AmitM]

HI Raghu, looks like in your query , you need to take down extra ''. '${Application}' to ${Application}

It is taking your variable as actual string and hence not finding any user group of such name

select userkey from user_groups ug join usergroup_users ugu on ugu.USER_GROUPKEY = ug.USERGROUPKEY and user_groupname=concat(replace(${Application}, ' ', '_'), '-HA')

Try it!! Good Luck !!

Regards,

Amit

If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

[CR]

Thanks for Response @AmitM .

Even we tried without '' also same we getting.

2024-02-02T10:36:05+05:30-arsms-c.s.s.a.controller.RequestController-http-nio-8787-exec-10-DEBUG-Response:: {enableBulkApproval=true, showActions=true, allowChangingApprover=true, noRecords=false, requests=[{requestedFor=AbiramaSundhari Ramanathan (917574), processInstanceID=MADL_AddAccessRequestWF_Final_V2_parallel.9023338, endpoints=Vector, accessApproversPk=17952, requestType=Enable Account, requestKey=4692, requestDetails=Vector - RABIRAMAOVC1I4TG Attributes-ACCOUNTKEY:5366376, requestOrigin=UI, dueDate=2024-02-03 05:05:57.0, platformType=null, requestor=KammariRaghu Chary (931813), reqId=9023338, requestDate=2024-02-02 05:05:57.0, processInstanceidNew=MADL_AddAccessRequestWF_Final_V2_parallel.9023338, jbpmActivityName=Enable Product Onwer, assignee=[Administrative User (admin)], businessJustification=null, accessApproversKey=[1], status=REQUEST.ACCESS.STATUS.OPEN}], message=Successful, enablePopOver=false, bulkApprovalCommentsFlag=false, defaultRowCount=20, allowAcceptReject=false, allowModifyRequest=true, requestRejectCommentsMandatory=false, requestAcceptCommentsMandatory=false}