nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Ryan Frazier_punyxq

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

Accepted answers

Brant Schroeder

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

All comments

Brant Schroeder

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud