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

Question

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?

Trudy P Claspill · Answer

@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

Ingrid de Bont · Answer

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:

Ingrid de Bont · Answer

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 ;-)