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 Frazier There are several options for sprints in JQL
I think you need to use the one in bold.
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.
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
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...