From the sys_hub_flow table and the sys_hub_action_type_definition table can I deactivate Flows, Sub Flows and Actions?

[Dave65]

Since Flow Designer itself, has no way to deactivate sub flows or actions, I am wondering if you can SAFELY deactivate them from the sys_hub_action_type_definition table (Actions) & sys_hub_flow table (Flows and Sub Flows).

I noticed that when I Deactivated the main flow, the Active column value on the sys_hub_flow table changed from true to false.

We are decommissioning an application that was not truly written as an application so it has code spread all over the place. I would like to be able to deactivate the Sub flows and actions before we remove all the code from the system in case some other flow is calling them that we are not aware of as there does not seem to be an easy way to find all references to a sub flow or action.

Thank you for your help.

[Maik Skoddow]

Hi

yes, basically this is possible. Some time ago I watched a video in which someone activated and deactivated several flows in one go via the list view, but unfortunately I cannot find anymore the link.

The question of referencing flows is a little trickier. As I was in a similar situation I invested some time to find out what business logic is built into all (Sub-)Flows. I posted the result at LinkedIn

The trick is to look into the table sys_update_xml. Here you can find the XML representation of all artifacts allowing to perform pure text searches:

Maybe it helps.

Maik

[OlaN]

Hi,

If you simply need to find out which Subflows are used in which Flows, you can find it in the table:
sys_hub_sub_flow_instance

Same thing with Flow actions, these can be found in the table:
sys_hub_action_instance

[Dave65]

I may be wrong but those tables only show if there are "Current" instances of the Flow, subflow, action running. They don't indicate if the the subflow or action are called from a flow that is not currently active.

[OlaN]

Partly correct. These tables list all instances of subflows and actions, and where (in which Flow) they are used. Not if they are currently running or not.

They do not tell if the parent Flow is Active or not, but you can select to filter the list to show only active/inactive Flow (just like any other list).

Like this: