Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,472
Community Members
 
Community Events
168
Community Groups

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

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:

Screen Shot 2022-08-11 at 5.36.17 PM.png

 

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

 

Thanks in advance!

Ryan

1 answer

1 accepted

0 votes
Answer accepted
Brant Schroeder Community Leader Aug 11, 2022

@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.

@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  

Hi @Ryan Frazier ,

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

Like # people like this
Brant Schroeder Community Leader Aug 12, 2022

@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.

Like Ryan Frazier likes this

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

Like Brant Schroeder likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

5,075 views 18 32
Read article

Atlassian Community Events