nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sort values in Sprint field

rhylton

Good day.

I am trying to get my sprint values sorted when i pull an extract for Jira.

Currently it comes out like this:

B, D, A, C

I need this:

A , B, C, D, E (asc or desc)

I've seen a few similar posts, but they do not provide the results that I need, or I blindly missed it.

Please advise, thank you.

Accepted answers

Bill Sheboy

Hi @rhylton

Short answer: that is not possible with out-of-the-box features of Jira's JQL.

Longer answer:

When writing a JQL statement, an ORDER BY expression can be added to sort the resulting issues. However that expression has no impact on any list fields with multiple values for each issue, such as Sprint, Fix Version, Labels, etc. As there is no documentation on outputting the values of a list field, I would assume the order is undefined / random.

A work-around for your scenario is:

export your issues to a spreadsheet
use spreadsheet features and functions to order the list fields, as needed

Kind regards,
Bill

All comments

Ste Wright

Hi @rhylton

What order are you specifically seeking? Is it...

Rank - i.e order in the backlog
Alphabetical
Created Date

...?

Know what you're looking to achieve will help to drive the best suggestion

Ste

rhylton

Hey Stephen.

Alpha or Numerical is desired, asc or descending.

My sprints are labeled as Sprint 1, Sprint 2, Sprint 3, and so on.

Ste Wright

Hi @rhylton

The Sprint field is ordered by Sprint ID - so it depends on which Sprint was created first.

You might be able to place the Sprint Name/Number into a separate field, and filter by this? But there could be complexities if an issue is in more than one Sprint, etc.

Ste

rhylton

Good day Stephen.

I'm not sure if I explained it well.

In my extract, these are the columns that i get, for example.

Key, Summary, Project, Sprint

The Key will be the Jira id,
The Summary is the title of my Jira ticket,
The Project is a custom field we created, and
The Sprint is the sprint value.

The excel comes out as the columns shown,

JIR-12 | Build Registration | CSite | SprintA, SprintC, SprintD, SprintB

JIR-13 | Build Login | CSite | SprintC, SprintD, SprintB, SprintE

JIR-14 | Build Welcome Page | CSite | SprintE, SprintD

What i would want to get is each time I dump the sprint column in an excel, it should always be shorted. That may be Alpha or Numeric, ASC or DSC.

"You might be able to place the Sprint Name/Number into a separate field, and filter by this?"

I do not understand what you are suggesting here, mainly because i don't think it works for what i want to do. The sprint is indeed in it's own field already. I can filter down based on the content of the sprint, or even EMPTY, or openSprint(). Those all work, but i need the values stored in there to be represented as a proper sequence.