Jira Cloud for Sheets can no longer sort by a custom field

[Michael Flores]

This is new as of the week of January 20, 2025.

1. In a Google Sheet, go to Extensions > Jira Cloud for Sheets > Open
2. Click "Get Issues from Jira"
3. In the Issues tab, use JQL in a query that will pull in a set of issues, and include in the query that the issues are to be sorted by a custom field. For example, "ORDER By cf[12345]" should be at the end.
4. Click "Refresh Issues" or "Get Issues Now"
5. Observe the sort order of the issues which populate the sheet

I would expect that the issues will populate the sheet sorted by the custom field indicated in the JQL. Instead, issues appear to be sorted by the first non-custom field.

If you instead include in the JQL "ORDER By Components ASC" or any other non-custom field, then the issues will populate correctly according to that field.

This may be related to Bug API-280 but I am 100% sure that it is not a duplicate of that.

[Aron Gombas _Midori_]

@Michael Flores Can you try if you run the same JQL search from the Jira web interface, does sorting work as expected?

It helps to troubleshoot the problem and narrow down its root cause, because:

1. If it works on the Jira web interface, then it is a bug in the app (or the REST API that serves it).
2. If it doesn't on the Jira web interface, either, then the bug is not in the app, but in executing the search. In that case, I would investigate the custom field further.

[Michael Flores]

Hi @Aron Gombas _Midori_ , thank you for taking a look at this.

The same JQL search does work as expected in the Jira web interface.

I have had to redesign the way my sheet works as a workaround, but would be happy to be able to return to the original version someday.

[Aron Gombas _Midori_]

@Michael Flores An, OK. If the sorting is important to you and it works on the web interface, you could try the Better Excel Exporter app, as well. It is developed by us and it obeys the sorting, so should work as expected. 

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)