How to I export only backlogged issues to a csv

[McKenna Hogan]

Hello, I want to export just my backlogged issues in my Jira project to a CSV. I can't find any options in the filters to filter my project by only backlogged issues. How do I do this?

Thanks!

[Trudy Claspill · Accepted solution]

Hello @McKenna Hogan 

A "backlog" is dependent on the Agile board you are viewing. An Agile board's content is based on a filter. The filter may be all issues of a single project, a subset of issues, or issues from across multiple projects.

Next, the backlog depends on whether the board is a Scrum board or a Kanban board.

If the board is a scrum board then an issue is "in the backlog" if it is not currently assigned to an Active sprint, and it is not in a status that is part of the "Done" Status Category.

If you have Kanban boards in the mix then the next question to ask is if the Kanban boards are for Team Managed Software projects or Company Managed Software projects.

For Company Managed Software projects an issue is "in the backlog" based on its status, and how statuses are mapped to columns in the Kanban board.

In Team Managed Software projects issues can be in any status and be in either the Backlog or on the Board.

So, with answers to the following questions, we can provide more explicit suggestions:

1. Is the board for the project a Scrum Board or a Kanban board?

2. Do you have more than one board for the project?

3. Is the project a Team Managed project or a Company Managed project? That information can be found in the Type column on the View All Projects page under the Projects menu.

[McKenna Hogan]

Thanks for the help,

1. The board is a scrum board.

2. We only have one board for the project. 

3. It is a Team managed project.

[Trudy Claspill]

Hello McKenna,

Thank you for sharing that information.

For future reference you may want to explore the Advanced Issue Search functionality.

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

And the free training available at Atlassian University concerning issue searches.

https://university.atlassian.com/student/catalog/list?search=jira+JQL

You should be able to use this for your filter:

project = <fill in your Team Managed project> and statusCategory!=Done and (sprint is empty or sprint not in openSprints()

Do you want to exclude items that are in planned but not started sprints? If you do then use this filter:

project = <fill in your Team Managed project> and statusCategory!=Done and (sprint is empty or (sprint not in openSprints() and sprint not in futureSprints() )

[McKenna Hogan]

This helps a lot. Thank you!