How do I search catalog workflow activities for a specific assignment group?

[Joseph_Wheeler]

My customer has ~300 workflows and would like to run a query to find out which workflows contain activities which have been assigned to a specific group.

I've seen ways posted to search for specific javascript.   Any idea on how to query instead on the Assignment Group variable?

Thanks much!

-Joe

[Pradeep Sharma]

Hi Joseph,

So you are looking to run a query for already completed workflows. Now you want to fetch the assignment group variable and do query on all the existing workflows to see what was the group. Is my understanding correct?

[Joseph_Wheeler]

Hi Pradeep,

Actually they want to search all workflow activities (not just actively running ones).

For example, Assignment Group A no longer does Request work.   All activities in all workflows need to be changed from A to a different group, named B.

Rather than manually checking 300 workflows to find out which ones contain activities assigned to Group A, they would like to run a query.

Thanks.

[Community Alums]

I thought maybe we could create a report on Workflow Activity [wf_activity] to help you out here, but because the activities can store the assignment group in different variables, this becomes a bit problematic. It does, however, look like you could report on this, but it gets a little tricky and may require multiple reports to do it right.

For example, create a report on the Workflow Activity table to report on what groups are assigned as the Fulfiller on catalog tasks. To do this, you need to go through the Variables table.

Another report could show you the Fulfillment group for Create Task activities.

This is just from a quick inspection, but there may be an easier way to do this. I hope this jumpstarts something to help you out, though.

[shane_davis]

I realize this post is old, but I am trying to do basically the same thing.  My goal is to search published, active workflows where there is a catalog task activity where the fulfillment group is "Test".  Any help is appreciated!