How to Get the Total Count of Projects Per Workflow in JIRA

Still need help?

The Atlassian Community is here for you.

Ask the community

Run the following SQL query (note: This query is written in MySQL syntax.  You will have to change the syntax to run on another DB)

select wse.workflow, count(p.pname) as `Total number of projects that use this workflow`
from nodeassociation n
inner join project p on p.ID = n.source_node_ID
inner join workflowscheme ws on ws.ID = n.SINK_NODE_ID
inner join workflowschemeentity wse on wse.scheme = ws.ID
where n.source_node_entity = 'Project' and n.sink_node_entity = 'WorkflowScheme'
group by wse.workflow
order by workflow;

Last modified on Mar 30, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.