You are viewing limited content. For full access, please sign in.

Question

Question

Display if workflow is an invoked workflow

asked on November 14, 2018

Hi All,

 

Is there a way to see within a workflow, if the workflow you're looking at is configured in another workflow to be invoked?

 

If not could I make this a feature request please?

 

It does tell you if you try to delete the workflow, but would be nice to have it displayed somewhere, so if you're trying to un-ravel workflows you know it's an invoked workflow.

 

Cheers!

1 0

Replies

replied on November 14, 2018

There are two ways that I have found of doing this:

First, within the WF Designer using the Edit->Find - Whose properties contain Your_Workflow_Name
The downside of that is it will only search WF that are currently open in the designer.


Second is querying the WF database:

SELECT TOP (1000) 
workflow_name
,designer_code
,last_update
,version
 FROM [LFWorkFlow].[dbo].[workflow_code] WF
 join [LFWorkFlow].[dbo].[index_workflow_name] WFN on WF.workflow_id = WFN.workflow_id
 where designer_code like '%<Name>YOUR WORKFLOW NAME HERE/Name>%<Parameters />%'

If you look at the designer_code field of a workflow, it's an XML file.   The 'Invoke Workflow' activity has a format within the XML field similar to:
<Workflow>
       <Id>-1</Id>
       <Name>Your Workflow Name Here</Name>
       <Parameters />
</Workflow>
Thus searching for:  '%<Name>YOUR WORKFLOW NAME HERE/Name>%<Parameters />%'

Hopefully that helps .... 

3 0
replied on November 15, 2018

Thanks Andrew, very useful, however I feel this should be something that is offered 'out of the box'.

2 0
replied on November 14, 2018

That would be handy!  The best you could do in the mean time is make a note in workflow x that it is invoked by workflow y.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.