Need JQL to identify issues that were closed at the end of a sprint and reopened in the next sprint

Question

Is there a JQL that can identify stories that were closed at the end of  a sprint and reopened the following sprint??

Bill Sheboy · Answer

Hi @Lorinda Quesenberry

Yes, and...to Jack's answer...

The difficult part of your use case is "following sprint", as I do not believe that is possible with out-of-the-box JQL.

If you only check if issues were done, re-opened, and in an unfinished sprint, this could work:

project = myProjectName 
 AND status WAS Done
 AND status != Done
 AND (sprint IN openSprints()
      OR sprint IN futureSprints())

Kind regards,
Bill

Jack Brickey · Answer

Maybe this gets you there. It ignores the sprint bit but displaying the sprint field might be sufficient.

status was done and status != done

now if you need to find situations where the issue is now closed (again), that is you want to find issues that are "reopened" but currently closed, then I suggest you add a label "reopened" using Automation. This will allow you to more precisely query for your needs.