resolved issues getting added to future sprints

[Uday Kiran Raparthy]

When a new sprint opens up (First day of the sprint) we see old user stories that were closed in the past sprints show up in the newsprint.

There are over 3k issues that must be reviewed, found with this JQL

• statusCategory = done AND sprint in futureSprints()

What we need to do is, Where the user is an "XXXX" that added it to a future sprint we want to undo the change.

Can we query the Jira DB for sprint-related information on Issues to get this data? If yes, please share some example query's.

[Uday Kiran Raparthy]

.

[Nic Brough -Adaptavist-]

Issues will go into the next sprint if they are not "done" when you end the current sprint.  (And for issues with sub-tasks, they can only be "done" when all their sub-tasks are done as well)

Jira only recognises the last column on the board as "done".

The database is a terrible way to try to query this stuff, what you should do is amend your JQL to search for the affected issues.

• Go to the board
• Use "configure" to check what status you have in the last column
• Run "status not in (all the status in last column) and sprint in futureSprints()"

[Uday Kiran Raparthy]

@Nic Brough -Adaptavist-  Thanks for responding 

the boards are configured properly and we see old user stories that were closed in the past sprints still show up in the newsprint in the last column.

Ran the JQL but still seeing over 1k issues

status in (Withdrawn, Done, Closed) AND Sprint in futureSprints() AND issuetype != Sub-task

[Nic Brough -Adaptavist-]

Ok, so you have not really "closed" those issues - they're not in a status that the board that the sprint looks at has in the last column.