Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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



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


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()...

3 answers

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 

0 votes
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.
Feb 24, 2023 • edited

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 {{}} (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,

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Feb 24, 2023 • edited

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,



Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events