List Flow with specific group

[Karine_M]

Hi all,

I need to list all flows that have at least one task assigned to a specific group.
I found information in the 'sys_variable_value' table with variables = Fields and value contains 'assignment_group' but the information of some sc_tasks does not go back to this table. Do you know if there is another table where I can find all the tasks and variables related?

Regards,

Karine

[Dnyaneshwaree]

Hello @Karine_M , 

Please elaborate your issue for better understanding.
Or
if I am able to understand your issue in some instant then for to see variables and their values then check the "sc_item_option" table and if you want to find tasks assigned to a specific group so you can filter tasks based on the assignment_group field then use "sc_task" table.

[Karine_M]

Hi,

I need to update the flows that currently assign tasks to group A to assign them to group B.
We have a large number of flows and I want to avoid editing them one by one so I am trying to list via a query all the flows that have at least one task associated with group A.

Regards,

[Dnyaneshwaree]

Then use "sys_flow_context" table which stores flow context records, and then filter by the specific group assigned to tasks within those flows. and you can use background script by glide record of flow context and task tables by mapping values of flow context and assignment group and print it.