How do I create a JQL filter that will show me all issues which have been in multiple sprints?

Question

I am trying to create a JQL filter that will show me all issues which have been in multiple sprints, without regard to whether it is in the current sprint. It would be nice if the sprints and dates were also available, but if I can just get the issues list that would be 90% of the problem.

Mark Benander · Answer

I know this is old, but perhaps this will help someone.  I further realize this said "without regard to whether it is in the current sprint", but that ends up being part of the solution.  This is what I've done to at least show me everything in the current sprint which has been carried over from earlier sprints:

Sprint in closedSprints() AND Sprint in openSprints()

At the very least, this shows me items in my current sprint that were carried over which I may want to dig into and make sure are moving along now.

Nic Brough -Adaptavist- · Answer

I've seen this done with a scripted field on server, that was able to rummage through the history to see where "close sprint" had pinged a story over to another one, and count the number of times it had happened.  JQL for "sprint jump count > 0" was then a simple clause.

But yes, it's a pain without coding, I don't think you can do it directly and en-masse, only by looking at each issue one at a time.

Mark Merizan_gbamlm · Answer

Thanks for the response. Yes, I knew how to determine if an issue had been in any sprint. We were specifically looking for a way to find issues that had been held over from one sprint to another multiple times. So we really needed the "count". But additional investigation suggests that I'm not the only one to try to do this and there isn't any good way. My work around was to export the data and do the analysis in external tools.