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
Thanks!
Hi @Olga Tchuvatkina ,
In fact, the board is based on a query. As I understand, you want this query, so go to the Configuration>General and Saved Filter or Filter Query.
Hope it helps !
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?
Olga
Hi Olga,
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?
Hi @Thomas Magny-Garcia
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'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 Everyone, have you tried to read this doc: https://confluence.atlassian.com/jirakb/jql-to-fetch-issues-in-scrum-board-backlog-and-not-part-of-sprint-1295390459.htmlIt might be helpful for all of us.Take a look.
It looks like you're new here. Sign in or register to get started.
