Total count of issues per status

[Adnan]

Please can you help me with an Sql query to get the total count of issues per status ?

[Deleted user]

Anyone know how to make this sort by the state ordering in your workflow?

[Thorsten Letschert _Decadis AG_]

Hi @[deleted] ,

all the statuses used can be re-ordered at

• yourCloudURL.atlassian.net/secure/admin/ViewStatuses.jspa (on Jira Cloud)
• yourBaseURL/admin/ViewStatuses.jspa (on Jira Server/Data Center)

This order is taken into account when sorting or grouping by statuses.

Cheers
Thorsten

[Deleted user]

Hasn't thought of that.....thank you.

Sadly I've inherited a bit of a mess there, so I'll have to proceed CAUTIOUSLY.

It would be nice to be able to do this "By Workflow", which is what make sense...shame that's not possible.

[Frederik De Roover]

Status = variable

Where variable is one of your defined statuses in a workflow.

• Open
• In Progress
• Done
• ...

Then below your query, you can see the total.

[Ollie Guan]

Hi @Adnan ,

Do you confirm that you need a SQL directly to the data query?

I think this part of the data can be displayed in the Dashboard through a simple JQL.

JQL:Any conditions you need to filter

Dashboard: Issue Statistics

[Adnan]

Hi @Ollie Guan 

First big thanks for your quick answer :)

I tried this way , but i have two problems :

1 - There's 519 statuses in my instance and the gadget can't provide an exhaustive view ,(only 266 lines)

2 - The issue count with JQL qurey is lower than the real issue count provided by sytem info .