how do I order a search in JIRA alphabetically?

Question

I am using the following JQL in attempt to get a list of all my epics, sorted alphabetically.

project = "My Project" AND issuetype = epic ORDER BY summary ASC

The issue is that the search is case sensitive (apparently by ascii codes) because everything in all CAPS is fine - SIP, SOAP, SOUP - but then "Sap" comes after SOUP.

If there is an upper case function in JQL, that ought to work.

Britt Lowry_lv7gke · Answer

good information, but like many  types of software, the answer to many longstanding often asked questions remain unanswered.  IMHO JQL needs functions like UpperCase()!

Mirek · Answer

HI @Britt Lowry

This is a very old issue..

https://jira.atlassian.com/browse/JRASERVER-20722

and I am afraid that there is no easy workaround to view the data in OOTB Jira. Maybe an addon or if you really need to get sorted data .. exporting it and sorting somewhere else (e.g. in Excel)