Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/31/2024 04:28 AM
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.
07/31/2024 04:31 AM - edited 07/31/2024 04:32 AM
Hi @Jasmeen , which character are you trying to replace.can you share text format.
And frocroles and frocoprional roles are dynamic attribute right?
07/31/2024 07:42 AM
Hi,
No I dont have the text format,
Yes both are dynamic attributes
07/31/2024 06:19 AM
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
07/31/2024 07:00 AM
Hi Rushikesh,
In the query with the dynamic attrobutes, eLearning group is also there, which is a static group, should it not be calculated?
07/31/2024 07:02 AM
Keep that group first in list
07/31/2024 07:43 AM
Hi,
I tried that, but it also did not work, approval is still going to admin.
07/31/2024 09:06 AM
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.⚠️‼️‼️