Issue Navigator not sorting by Status

scott.fawcett March 25, 2019

I want a single view that shows all the content for a release and the current Status of each ticket.  This is my way of monitoring how a release is going.

From what I've searched the only way to do this is in the Issue Navigator.  I added the columns I needed so it works at first glance.

But, I want it sorted by Status, primarily so I can see what's left to work on.  When I change the query and hit the refresh symbol there are no changes.  So, it's ignored my sort order entirely.  If I change it to sort on other fields it also ignores that.

A bug or something I'm doing wrong?

Is there any other way to see all the content of a Release and the fields I choose to see?

1 answer

0 votes
Shawn Masters
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2019

This can be handled in a large variety of ways....sticking to the issue navigator here is an Atlassian Article outlining "searching for issues" which should help you fine tune that navigator to provide you the results you are looking for:

 

https://confluence.atlassian.com/jiracorecloud/searching-for-issues-765593657.html

scott.fawcett March 26, 2019

I'm unclear as to how searching for a specific ticket relates to my issue.  That is not my problem.

 

I want to see the status of ALL tickets, in a single view, assigned to a release.  I am using the Issue Navigator to do that (I'm open to other methods), but that view ignores my sort criteria in the query.  Why does it ignore the sort in the query?

Shawn Masters
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 26, 2019

The issue navigator is a search tool within Jira. It is used to create filters which are then used to fine tune reports, dashboards, and a myriad of other things. So for example say you get this list of All Tickets that you are looking for. You can save that query as a filter and then use it to display that output in a dashboard or confluence gadget or use that filter to gather/display metrics. 

 

At the end of the query should be something like 'ORDER BY Status' which should allow you to sort your selection.  I dropped an example query from my own issue navigator below as an example 

project = INTERN AND issuetype = Incident ORDER BY status

scott.fawcett March 26, 2019

Here is the default query when I go into the Issue Navigator

project = 10000 AND fixVersion = 12582 ORDER BY priority DESC, key ASC

 

When I change it to the following the order does NOT change.

project = 10000 AND fixVersion = 12582 ORDER BY status, key ASC

 

When I change it to the following the order does NOT change.

project = 10000 AND fixVersion = 12582 ORDER BY status ASC

 

When I change it to the following the order does NOT change.

project = 10000 AND fixVersion = 12582 ORDER BY id

 

So, clearly the sort order does not work or I am doing something wrong.  If the sort order does not work, what other view will show me the status of all tickets assigned to a release sorted by Status...so I can focus on the work that is not yet complete?

Shawn Masters
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 26, 2019

Your queries look correct. The only scenario where the sort fails to work in my Jira Cloud instance is in the event the issues are all actually in a "Done" status. This usually happens when the developer/project manager uses an old fixVersion. 

 

I would provide you another suggestion which is using a "Filter Result" gadget in a Dashboard BUT if the initial query you are using isnt working neither will the report. Verify you have the right project and FixVersion...if you do I would reach out to your admin and let them know your Sort function is not working as expected. 

Suggest an answer

Log in or Sign up to answer