Find which workflows that uses a specific validation plugin

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?

3 answers

1 accepted

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.

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%');

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

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).

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,739 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot