JQL Query for Filter search

[Mitesh Shah]

I have created a filter and used JQL to get the desired information,

issuetype = "Request a change" AND project = ISD AND updated >= 2020-03-05 AND updated <= 2020-04-14 AND assignee in (membersOf("IT Service Desk")) ORDER BY statusCategory ,status

The issue I have is with Order BY, it is doing the order by correctly for the status assigned to the statuscategory (from what I feel) with a status category for ToDo, but when the different category comes into play the order by plays up,

How does the Order by work. does it Order By StatusCategory first and then Status? And if this is the case, on what basis does the sorting happen?

[Mohamed Benziane · Accepted solution]

Hello @Mitesh Shah 

The order by will first order by statuscategory (in your case) then if two issues have the same statuscategory jira will order by status.

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-24

Hope this helps