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.

 

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()"