Does anyone know how to customize the sort order of the Issue Statistic Gadget?

[Matt Robbins]

We are using the Issue statistics to display on the Status of an issue. However the sort order options available are 'Natural' or 'Total' neither of which sort it the way we want. We would like it to sort in the order they would come in the workflow. Any help on knowing how to do this if it is even possible would be great.

[Renjith Pillai · Accepted solution]

I guess no with the standard Issue Statistics Gadget.

[Matt Robbins]

Yah that is what I was thinking as well. Just wanted to see if anyone knew of a way. Thanks!

[Matt Robbins]

We actually found a way to do this.

You have to update the DB on the backend and then restart the server. Here is the script we used:

update issuestatus set SEQUENCE=3 where pname='New'

update issuestatus set SEQUENCE=4 where pname='In Prioritization'

update issuestatus set SEQUENCE=6 where pname='Pending Development'

update issuestatus set SEQUENCE=21 where pname='Needs More Information'

update issuestatus set SEQUENCE=28 where pname='Reopened'

update issuestatus set SEQUENCE=44 where pname='In Development'

update issuestatus set SEQUENCE=57 where pname='In Progress'

The status' are in the 'IssueStatus' table.

[Narasimha Charya Vedagopuram]

Do we have similar way for people on JIRA Cloud, as we want to display the two dimensional gadget to show the order or workflow sequence in X-Axis?

[Lucas Smithbauer]

I know this answer is a decade old but is a Jira restart necessary for the sorting changes to take effect?