Problem with sorting multiple fields in JQL query

Question

Hello - I have found other questions in the community but the answers don't address my issue. I'm attempting to sort by Parent and then by Status  by using this at the end of  my query: ORDER BY parent ASC, status DESC. The result is ordered by Parent and then Issue Number/Key (example below)

Parent    Status

A             To Do

A              In Progress

A              To Do

Any ideas as to why?

Bill Sheboy · Answer

Thanks, Andy.  I look forward to learning how this can be improved over time.  Certainly any unexplained search results create work for customers and the support team answering their questions.

Andy Heinzer · Answer

@Bill Sheboy I initially had the same suspicion that fields that might have a null value could be the cause here, such as parent.  However when testing the order by with only the status field, I found I could still replicate the behavior.  So the potential of null values are not the cause of this.

Instead I believe this is happening because of the nature of team managed projects in regards to how fields like status are not the global context field like they are in Company managed projects.

Sheri Maxim · Answer

@Andy Heinzer  thanks for the response and explanation. I'll track the reported bug.

Regards,
Sheri