Issues moved to backlog still appears under Closed sprints JQL Query

Question

I closed a sprint a sprint and moved the unfinished issues to backlog. But when I execute the project = XXX AND Sprint in closedSprints() the issues appears under closed sprint as well.

I did verify that the issue is in backlog but why it is also part of closed sprint search results

Thanks

Yugank Bhatnagar · Answer

Thanks but my original issue was part of completed sprint that was closed and then moved to another sprint which is NOT closed. I performed the Bulk edit on Sprint field as blank but it cleared all sprint values including closed,Future etc. For now I am good, thanks for your help.

Simple Tyler · Answer

You can exclude any issues that are in an active sprint by adding: "and sprint not in openSprints()" to your query to avoid impacting any active sprints.

Yugank Bhatnagar · Answer

Hi

Thanks for the explanation but this solution also comes with other problems.

Before

And in JQL

Issue appears in Closed sprints as well.

Perform Bulk Edit Step

Select Change Sprint and edit the value accordingly - if you don't want the issue to be associated with any sprints, leave the field empty;

After

Clears all Sprint values and the issues are back in Backlog, if it would have been an active sprint then I have to re-add the issues to sprint and that event would generate scope change and impact reporting.