JQL looking to create a filter for a dashboard that is looking for tickets without a sprint assigned

[Ryan Frazier]

First time poster, long time viewer.

I am looking to create a dashboard to see all tickets in the backlog that do not have an assigned sprint with a few other factors included using this filter:

project = cp AND component = Web AND status not in (Done, "Won't do") AND "Story point estimate" = EMPTY AND issuetype != Epic AND Sprint = null and key not in (CP-4709, CP-2243) ORDER BY issuetype ASC  

The problem I am running in to is that there are 55 tickets in my backlog but this query only brings up 33 tickets because of tickets that had a sprint but no longer do (the sprint field technically isn't null or empty) as found in this screenshot:

Anyone have any idea how I can include tickets like this in my single query?

Thanks in advance!

Ryan

[Brant Schroeder · Accepted solution]

@Ryan Frazier There are several options for sprints in JQL

• "Sprint is empty" - To find tickets that do not belong to any sprint
• "Sprint not in openSprints()" - To find tickets that are not in any current sprint
• "Sprint not in closedSprints()" - To find tickets that are not in any completed sprint
• "Sprint not in futureSprints()" - To find tickets that are not in any sprint being prepared

I think you need to use the one in bold.

[Ryan Frazier]

@Brant Schroeder 

Thank you for reaching out so quickly.  I probably should have mentioned I have tried these filters as well.  When using opensprints(), it will show the items that had been previously in a sprint but removed and placed in backlog, but it will not show items that have never been in a sprint and are sitting in a backlog.  

I am trying to figure out a way to combine those in the same query but every time I try, it starts pulling tickets from different projects.  

Something like:

project = cp AND component = Web AND status not in (Done, "Won't do") AND "Story point estimate" = EMPTY AND issuetype != Epic AND Sprint = Empty OR sprint not in openSprints() and key not in (CP-4709, CP-2243) ORDER BY issuetype ASC  

[Thuan_ Do Dang]

Hi @Ryan Frazier ,

You should wrap OR operation like this ... AND (Sprint = Empty OR sprint not in openSprints()) AND ...

[Brant Schroeder]

@Ryan Frazier what @Thuan_ Do Dang has said would be my recommendation as well.  You should be able to use an OR clause to get the correct combination to display the information you are after.

[Ryan Frazier]

@Brant Schroeder @Thuan_ Do Dang  You both are awesome.  Thank you so much for the help!