Issues moved to backlog still appears under Closed sprints JQL Query

[Yugank Bhatnagar]

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]

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.

[Tyler Brown]

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]

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.

[Tyler Brown]

Hey Yugank,

Since those issues were included in the Sprint, and that Sprint has been closed they will still be included in the closed Sprints() query (those issues would still be tagged with the old Sprint).

You may be able to remove the old Sprint value from the tickets to exclude them from your query.

Hope this helps,

Tyler

[Yugank Bhatnagar]

Thanks can you please suggest a way to remove the Completed Sprints value so that I can manually remove them. I included the sprint field but I couldn't locate the 'Completed Sprint' field'

Thanks

[Tyler Brown]

Hey Yungank,

You should be able to bulk edit your issues.

Change the Sprint field value to be blank and that should remove any completed sprint values from your issues.

Full description ca be found here: https://jira.atlassian.com/browse/JSWSERVER-10548

Tyler