Filtering issues that moved from previous sprint to current

yosi hatem February 21, 2024

Hey All,


I have some issues which they moved from the previous sprint(closed) to the current sprint(open).

Is there a way to filter this by using JQL


Please note that the same issues might be moved multiple times. so need some dynamic query and not a specific sprint name


Thanks in advance

2 answers

1 accepted

2 votes
Answer accepted
Tansu Akdeniz
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 21, 2024

Hi @yosi hatem 

Please take a look at the answers in this thread:

yosi hatem February 21, 2024


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.
February 28, 2024

Hi @yosi hatem

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues 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 number of sprints, the latest sprint, and many others. 

With these, you can build a view like e.g. this in just a couple of clicks:


As you can see above, you can easily sort and filter by the number of sprints, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,



Suggest an answer

Log in or Sign up to answer