Is there a way, using JQL, to find issues which have been in more than one sprint?

Question

I want to be able to run a search with my team which shows all the issues that are in a specific sprint AND have been in more than one sprint.

This is so that I can make sure tickets aren't hanging around too long and that as a team we can go through this list regularly. I can see how to look for issues in a specific sprint (or specific set of sprints), but not for sprints > 1.

Any ideas?

John Fetzik · Accepted Answer

You cannot get a count of sprints an issue has been in without an add-on.

You can use a combination of the openSprints(), futureSprints() and closedSprints() functions to see if an issue is in a current/future sprint and has been in a previous closed sprint. No counts however.