Identify the last sprint a ticket has been assigned to / LastSprint FixSprint

Question

Hello,

We would like to be able to identify tickets by the sprint the ticket has been delivered in, as opposed to all the sprints the ticket has been in.

Ideally this would be doable in JQL with something like "LastSprint" or "FixSprint" such as:

LastSprint = 1234

or

Sprint = LastSprint(1234)

Has anyone had the same need ? and found a solution ?
I'm even considering an extra field and some automation.

PS : Please note that this is not the same thing as openSprints() and closedSprints()...

Raul H Marrero · Answer

I have the same need. I must identify which is the last sprint assigned to an issue among the history that for any reason the issue passed through

Bill Sheboy · Answer

Hi @JG Meillaud _

To do this with an automation rule, and have the results reportable later, you will need a custom field and a rule.  You will need to decide what data you want to save for the sprint, such as the name, id, etc. or perhaps a mashup of the sprint attributes.

How to...

* add a custom field, such as Fixed In Sprint
* add an automation rule...* trigger: sprint completed
* branch: on the issues in the sprint* condition: to check if the status is "done" (This avoids marking any carried-over items.) 
* action: edit the custom field to set it to {{sprint.name}} (or the fields you wanted)

You can theoretically set this for older, completed sprints' issues, with some assumptions and a more complex rule.  (For example, assuming that the most-recent sprint is the "Fixed In Sprint".)  I recommend ignoring that rule unless you really need it.

Kind regards,
Bill

Hannes Obweger - JXL for Jira · Answer

Hi @JG Meillaud _

I wouldn't be surprised if this could be done via automation; after all, Jira keeps track of all sprints of an issue, so it's very likely a matter of getting ahold of the latest one. Since I don't have a lot of experience with this myself I'm afraid I have to leave the details to the experts - sorry!

This being said, if you're open to solutions from the Atlassian Marketplace, this would be easy to do - i.e., without any scripting or automation required - with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called "smart columns" that aren't natively available, including the last sprint (along with several other sprint-related columns).

This is how it looks in action:

As you can see above, you can sort and filter by this column, and also use it across JXL's advanced features such as issue grouping, sum-ups, or conditional formatting. Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Hope this helps,

Best,

Hannes