JQL ideas: tasks that has been in more than one sprint

[Gonzalo Fernández Durán]

Hi community,

i would be very thankful if somebody could help me with some ideas about a JQL filtre that i am trying to build. I need issues that has been in more than one sprint. i am using the sprint default value, but probably i´d need to create a custom field in order to count sprints...

Thanks a lot!

[Ste Wright]

Hi @Gonzalo Fernández Durán 

It depends on the need.

----------------

If you're looking for open issues which were in a closed sprint - and are in an open or future sprint, you can do this via JQL:

Sprint in closedSprints() AND (Sprint in openSprints() OR Sprint in futureSprints())

----------------

If you're just looking for any issues which are or were in more than one sprint, I'd advise using a scripting app - such as Scriptrunner - to created a scripted field, to count the number of sprints an issue has listed against it.

You could then use JQL to search against the counter, to see issues in >1 sprints.

Ste