nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find which workflows that uses a specific validation plugin

Michael Danielsson

We have some old plugins that we want to stop using since JIRA now contains the functionallity these plugins provide.

Is there an easy way to find which workflows are using these plugins?

I have tried to look in an xml backup, but the backup is very large so it is hard to do it this way.

We also have a lot of workflows so it would be a lot of job to export each workflow to an xml.

Is there a way to export all workflows to one XML?

Accepted answers

Krzysztof Skoropada [Deviniti]

Hi, Michael,

You mentioned all the possible options as I guess. XML backup is the best I think - all in one place. But.. workflows are stored as a CLOB on database, so try to build sql query to select it.

All comments

Krzysztof Skoropada [Deviniti]

Hi, Michael,

You mentioned all the possible options as I guess. XML backup is the best I think - all in one place. But.. workflows are stored as a CLOB on database, so try to build sql query to select it.

Cyril Egan1

Go to the workflows section in the administration area. Right click on the XML link beside all the workflows you want to search and save them as a files to your local computer. Then search each file for what you need.

If you don't know what text to search for in the workflow then create a test workflow and add functionality from the plugin to it. See what got added to that one. From there you should be able to figure our your search string(s).

Michael Danielsson

I used the following SQL question to find which workflows and workflowschemes that used the plugin

SELECT 
  workflowscheme.name,
  workflowschemeentity.scheme,
  issuetype.pname,
  workflowschemeentity.issuetype
FROM 
  issuetype,
  workflowschemeentity,
  workflowscheme
WHERE 
issuetype.id = workflowschemeentity.issuetype and
workflowscheme.id = workflowschemeentity.scheme and
  workflowschemeentity.workflow in
	(SELECT 
		jiraworkflows.workflowname
	FROM 
		jiraworkflows
	WHERE 
		jiraworkflows.descriptor like '%com.company.plugin%');

Murat BALKAS1

Thanks for this SQL. Helped me for checking if "JIRA Workflow Toolbox" plugin used or not. Murat

BBC Application Admin Team

Hey,

I've tried the above SQL query, as well as the console script from here -

https://community.atlassian.com/t5/Jira-questions/How-to-find-all-workflows-which-are-using-postfunctions-of-a/qaq-p/175074

I'm only getting workflows that are using JMWE for post functions returned. Neither method seems to find workflows that are using JMWE for validation.

Is anyone else finding the same? / Found a solution?

Note: We have a very large Jira instance so its not feasible for me to start manually downloading the XML for them all. Thanks

BBC Application Admin Team

Found the answer to the above - script at the very bottom of the thread works fine.