How to Get the Total Count of Projects Per Workflow in JIRA
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
Powered by Confluence and Scroll Viewport.