Sort values in Sprint field

rhylton November 24, 2023

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.

2 answers

1 accepted

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 30, 2023

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:

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

Kind regards,
Bill

rhylton November 30, 2023

And there in was the answer I didn't want to hear.

I did something along those manual lines in Excel, but figured there may had been a better approach.

Thank you.

@Ste Wright 

Let me know if you have a different opinion vs what Bill has shared, please.

Thank you.

0 votes
Ste Wright
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 24, 2023

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 November 24, 2023

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 24, 2023

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 November 27, 2023

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.

SprintA, SprintB, SprintC, SprintD, not something jumbled.

Ste Wright
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 30, 2023

Hi @rhylton 

What are the Sprint IDs for Sprints A through E?

Ste

rhylton November 30, 2023

Good day, Stephen.

I do not know how to get the sprint id.  Please advise and i'll get that info and share it.

 

 

Thanks.

Ste Wright
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 30, 2023

Hi @rhylton 

You can get the Sprint IDs from...

  • Searching in JQL - when you select the Sprint, the ID appears in its place
  • Sprint Report - check this report on your board; the ID is in the URL
    • eg. ...?sprint=3

Ste

oeti
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 24, 2024

(I see the post is already 10 monthes old...)

But still there is no method to sort a JIRA search by sprint like...

... ORDER BY MAX(Sprint) ASC, rank ASC

... because I would like to have a search result that lists the issues similar to the backlog page.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events