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
Was this helpful?Yes Provide feedback about this article
Powered by Confluence and Scroll Viewport.