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.
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:
Kind regards,
Bill
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.
Let me know if you have a different opinion vs what Bill has shared, please.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @rhylton
What order are you specifically seeking? Is it...
...?
Know what you're looking to achieve will help to drive the best suggestion :)
Ste
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @rhylton
You can get the Sprint IDs from...
Ste
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
(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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.