How can I exclude issues that are in the backlog via my JQL Query.
Hello @Derek Kauble
Welcome to the Atlassian community.
What is the current filter for your board?
What do you want to exclude?
project = "CS" and type = "Story - EDI" and status in (Connected, Testing, Started) ORDER BY created DESC
how do I include or exclude backlog issues from this query
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you working with a scrum board or a Kanban board?
Are you referring to the list of issues that appear under the heading "Backlog" on the Backlog screen associated with at same board?
Are you working with a Team Managed project or a Company Managed project? Find that information at the bottom of the navigation panel on the left when you are viewing the board
If you are working issues in a scrum board you can exclude the issues in the "Backlog" list by adding this criteria:
sprint in openSprints()
Learn more about using the Sprint field in filters from this document:
https://support.atlassian.com/jira-software-cloud/docs/jql-fields/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a Kanban board. Yes I'm referring to the backlog of the same board.
It is a team managed project.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In a Team Managed project Kanban board being in the Backlog is not based on the Status of the issue (as it is in a Kanban board for a Company Managed project).
Unfortunately at this time there is not a JQL option for checking if an issue is in the "Backlog" list or on the Board for a Team Managed project Kanban board.
There is a change request asking for such functionality to which you can add your vote/comments.
https://jira.atlassian.com/browse/JSWCLOUD-20433
In other Questions on the same topic users are relying on work arounds such as leaving the Assignee blank when the issue is in the Backlog, and then using that as the criteria for selecting/excluding the issues.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.