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

[Mark Roethof]

Hi there,

Have a look at the sys_variable_value table. Simply look for Value contains <your_sys_id> of your group.

The record(s) returned, contain the ID field, which references the Workflow Activity the Values record is attached to. Opening the Workflow Activity wf_activity, would also give you the Workflow you are after [Field: Workflow version].

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[shane_davis]

Mark,

    Thank you for the quick reply.  I looked for [Field: Workflow version] but do not have that field when clicking into wf_activity.  Is there a way to show the workflow names in the same list related to the wf activities that are brought back for the group?

Thank you,

Shane

[Nikita1]

Hi,

Do we have any query for it? I need to find all workflow for an assignment group. Can anyone help?

Thanks in advance!