To list open issue when complete the sprint

[Ramesh Krishnan]

When i do the 'complete' sprint in backlog or active sprint, its says there are open issues, how to find the list of open issue.

[Arnelys · Accepted solution]

Hi! @Ramesh Krishnan 

Option 1

You can use a filter: 

issuetype in (Task, Story, Sub-task, Bug) AND statusCategory != Done AND sprint in openSprints() ORDER BY created DESC

If you have more than one project or if you want to specify the sprint name, the filter can be:

project = 'X' AND Sprint = 'X' AND issuetype in (Task, Story, Sub-task, Bug) AND statusCategory != Done AND sprint in openSprints() ORDER BY created DESC

Where you can create the filter? I have a company managed project, I don't know how it is in a team managed project.
There is a menu at the top called Filters, create a new filter and insert what you need to search for, then you can export it if you want

Option 2

There is also an option called 'Issues', there you can insert the same filter that I mentioned above.

Option 3

Use quick filters, you can manage them from the backlog, More/Quick filters
You must have the necessary permission. 

you can use the same query or even a simpler one:
issuetype in (Task, Story, Sub-task, Bug) AND statusCategory != Done ORDER BY created DESC

[Varsha Joshi · Accepted solution]

Hi @Ramesh Krishnan 

I had the similar issue recently. I pulled the issues for the sprint using JQL, this way it shows all the issues that are closed/open etc.

JQL --> sprint ="yourSprintName"

Hope that helps.

Thanks

Varsha

[Walter Buggenhout · Accepted solution]

Hi @Ramesh Krishnan,

The open issues are all issues that are not in the rightmost column of your board in the active sprint.

Hope this helps! 

[Ramesh Krishnan]

Sorry, i didnt get that. Where i can find the list of open issues, so that i can review and update the sprint and complete it

it shows current iteration there are number of open issues.