workflow wrongly goes to Admin when JobFunction = "No Change"

[Jasmeen]

Hi,

We have an application with multiple level of approval.

1st level approval is going to manager correctly. 

where as in 2nd level approval we are using a query to  determine the usergroup and users 

query : select distinct ugu.USERKEY from user_groups ug join usergroup_users ugu on ug.USERGROUPKEY=ugu.USER_GROUPKEY where ug.USER_GROUPNAME in ('${FROCRoles.replaceAll(',','\',\'')}','${FROCOptionalRoles.replaceAll(',','\',\'')}','FROC eLearning')

But in this step, the approval is going to the Admin(admin) not the correct group, when there is no FROCROLES and FROCoptionalROles selected. (When Job function is selected as "No change" the above attribute will get hidden)

Even if FROCRoles and Optional Roles are NULL when JOb function = No change, Then according to this query it should go the ELearning team.

The attributes "FROC Roles" and FROC Optional Roles" , Job Function are dynamic attributes in ARS form.

How could we change this query to get it working properly.

[NM]

Hi @Jasmeen , which character are you trying to replace.can you share text format.

And frocroles and frocoprional roles are dynamic attribute right?

[Jasmeen]

Hi,

No I dont have the text format, 

Yes both are dynamic attributes

[rushikeshvartak]

Either or dynamic attribute should be mandatory. If those are not selected it will not find user group and request will be assigned to admin this is expected behavior 

[Jasmeen]

Hi Rushikesh,

In the query with the dynamic attrobutes, eLearning group is also there, which is a static group, should it not be calculated?

[rushikeshvartak]

Keep that group first in list

[Jasmeen]

Hi,

I tried that, but it also did not work, approval is still going to admin.

[rushikeshvartak]

Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .



‼️‼️⚠️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.⚠️‼️‼️