You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I want to return issues from the Board. What is the JQL Query to filter out Backlog in a project not using Sprint functionality? Since there no sprints for any issues, "sprint is not EMPTY" does not return any results
I'm a Jira user, not a Jira expert, so I may be wrong...
My understanding of Backlog is, this is all tickets with no Sprint assigned. If you're not using sprints, then all tickets are in the Backlog. Similarly, "Board" is the Sprint Board, which is the list of tickets assigned to the current sprint.
Please define what you mean by "Board" vs "Backlog". For you, what fields on a ticket control whether the ticket is a Board or a Backlog ticket?
HI Thomas, thank you for getting back to me
I want to create a filter that returns unassigned tasks from all projects. The query below picks up tasks from Board and Backlog, Is it possible to filter Backlog out?
issuetype = Task AND assignee in (EMPTY) ORDER BY updated DESC
It looks like I can do it by enabling sprints in my next-gen projects and filtering tasks with empty sprints, but is there another way that does not involve enabling new feature? Hopefully there is some JQL flag that distinguishes board from backlog
I looked through automatically saved queries but did not see any queries for next-gen projects boards. Board queries generated for classic projects were filtering only by project name so they are not really helpful for filtering out backlog. Am I looking in the wrong place?
You may use the sprint field like :
sprint not in openSprints ()
It should give you all issues that are not present in your active sprints, so present in the Backlog, don't you think?
Hope it helps !
Sprints are not enabled in these projects so neither Sprint is not EMPTY nor sprint not in openSprints () will work, unfortunately. Yet there is something other than sprints that distinguishes board from backlog, since Backlog can be enabled without enabling Sprints
I should ask the same question as @Bruce Reed What do you mean by Board?
As you aren't using Sprint, I guess you have a Backlog with all your tickets. You want to filter them to see only the important one for a specific use case for instance, using a Board (so a specific filter query) like this:
If you want all your Backlog, without any Board, I guess you will have to use a filter query that doesn't match any of your Board filter Queries... I hope you have some common factors... It doesn't seem really easy to me :/
Hope it helps !