Make a filter with the same results as the "Backlog"

[Ingrid de Bont]

I would like to use a filter for my Jira dashboard where I see all the userstories that are in the backlog and sorted the same way as they are in the backlog.

This applies to userstories with and without Epics.

I am currently using this SQL script:
Sprint = Empty AND Status != Production AND issue type != Epic ORDER BY Rank ASC

But I see that I am missing the userstories in the search result that are linked to an Epic.

The epics are not linked to a sprint. How can I make sure I get these in my search results as well?

Does anyone know the solution to this?

[Jack Brickey]

Hi @Ingrid de Bont , are you trying to achieve the results based on something similar to what I illustrate below? Specifically let's say you have some items show in your backlog that are part of an upcoming Sprint. I assume you want to exclude those? Moreover, you only want to include the true backlog as illustrated in green below. Is this the case?

Assuming so possibly the following JQL would work? However, that can be flawed as well in some corner cases, e.g. if you had an issue in the backlog that happened to be In Progress. The bottom line is it can be a bit complex depending on your circumstances. If you could give me more detail and maybe even a screenshot depicting what you want to include I could recommend further. Finally if all the complexity of the Sprint JQL stuff below is confusing let me know and I can try to explain my thinking.

project = XXX AND status = "To Do" AND type not in (Sub-task, epic) AND (sprint is EMPTY OR sprint in closedSprints() AND sprint not in (openSprints(),futureSprints())) ORDER BY rank ASC

[Ingrid de Bont]

Thank you for your reaction!

Since we only recently started working with sprints and releases, there are also userstories in the backlog with the status developed and active. This is not correct, I know. In the future this will not happen either.

The priority within the backlog is also determined by the rank of a userstory and I also want to see this order reflected in the result of my filter ;-)

I have added a printscreen of our current backlog:

I want to achieve the same result with a filter, but I don't see the userstories associated with an epic, see printscreens. 

Filter results:

[Trudy Claspill]

Are you working with a Company Managed project or a Team Managed project? That information can be found at the bottom of the navigation pane on the left.

[Trudy Claspill]

@Ingrid de Bont 

If some of the issues in your Backlog were in a previous sprint, did not get completed in that sprint, and were put back into the backlog at the end of the sprint, then the Sprint field will not be empty.

Look at the Sprint field for the issues that are missing in your filter output. Does it look something like this?

If so, then the sprint field is not empty.

You also need to make sure that you are using the Filter Query from your board as a base for your new filter. Try something like this:

<board's filter query> and type !=Epic and statusCategory != Done and Sprint not in openSprints() order by Rank desc

[Ashley Hudson]

Heya @Ingrid de Bont ,

A much simpler JQL: 

Project = XXX and status in (Backlog, Open, "To Do")

For the status in section, I'd assume you are using the status backlog for all of your backlog status's? If not, just replace it with the status that the backlog is matching against in your board! 

I hope this helps! 

Kind Regards,

Ashley Hudson

[Ingrid de Bont]

Thank you for your reaction!

Since we only recently started working with sprints and releases, there are also userstories in the backlog with the status developed and active. This is not correct, I know. In the future this will not happen either.

The priority within the backlog is also determined by the rank of a userstory and I also want to see this order reflected in the result of my filter ;-)