JXL: Is there a way to reorder issues? Or multi-level sort

[denis_bogdanas]

I'm sorting issues in JXL by priority. I'd like to have a certain order for issues of the same priority too. Either to manually order them like in Jira list view, or to define some secondary sorting criteria. Is that possible?

[Daniel Franz - JXL · Accepted solution]

Hello Denis,

Welcome to the Atlassian Community.

I'm on the JXL team and hope to be able to help out here.

Sorting

If you are looking to sort the issues in your sheet by multiple fields, use an ORDER BY clause in the JQL query (Jira Query Language) of your sheet scope. You can find the syntax here in Atlassian’s documentation.

Ranking

Alternatively, you can apply any arbitrary order of issues by using the ranking feature. To enable issue ranking, click the Ranking button in the toolbar above the table. If you have multiple Global rank fields in your site, a menu opens where you need to choose a field to use for ranking. Once this is enabled, issues in the table are sorted using the values of the Global rank field. Any other potentially enabled column sorting and any ORDER BY clause you might have defined in the sheet scope are ignored.

Now to re-position issues, select one or more row handles to the left of the table. Once you have made your selection, click again and hold the selected row handles to grab the rows, move the cursor to drag the rows to the desired position in the table, and release to drop them.

Hope this helps. If you have more detailed questions, also feel free to reach to us directly at support.jxl.app.

Thanks,

Daniel

[gr3enarr0w]

Hi @denis_bogdanas 

Welcome to community! Are you referring to JQL? JQL does not have a multi level sort, it's able to sort by ASC or DESC on a once per query function. This is a pretty good guide on JQL: https://www.atlassian.com/software/jira/guides/jql/overview#what-is-jql

Atlassian also has some training on their site which is where I learned from way back when: https://community.atlassian.com/learning/course/find-information-faster-with-search-and-filters-in-jira

If not can you share what you are referring to with JXL? I am unfamiliar.

Best,

Clark

[denis_bogdanas]

No, I meant JXL addon: https://jxl.app/