Approvals that uses change group for approvals

[Rairai31]

Hi,

I have a requirement to identify all workflows that use the change group for approvals. Can you please advise how can I check it? Thank you

[Community Alums]

• Navigate to Workflow Activities:

  • Type wf_activity.list in the filter navigator and press Enter. This will open the Workflow Activities list.

• Filter for "Approval - Group" Activities:

  • Add a filter: Activity definition is Approval - Group.

• Identify the Group in the "Variables" Field:

  • The Approval - Group activity stores the configured group(s) in its Variables field (which is a JSON or XML string, depending on the version and activity configuration).

  • You'll need to look for the groups variable within this string.

  How to filter for a specific group:

  • If you have the Group's sys_id: Add another filter: Variables contains [sys_id_of_your_change_group]. (e.g., variablesLIKEsys_id_of_your_change_group)

  • If you only have the Group's Name: This is trickier because the variables field often stores sys_ids. You'd need to first get the sys_id of your "change group" from the sys_user_group table (sys_user_group.list). Then use the sys_id in your filter.

• Identify the Workflow:

  • Once you've filtered the wf_activity table, the Workflow version field (or Workflow in some views) will show you the workflow that contains that activity. You can then click on the workflow to open it in the Workflow Editor.

[Ankur Bawiskar]

@Rairai31 

somewhat difficult to identify the workflows which are using that group.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Masthan Sharif]

Hi @Rairai31 ,

Try to see if 'sys_variable_value' table helps you with your requirement.

You can filter like table= wf_activity and value contains name or sys_id of the group.

Later you can group by ID to look into only the approval typeof workflow activities(Approval - Group or Approval - User) 

Best Regards,

Sharif