JQL to fetch Issues in scrum board Backlog and not part of Sprint
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
JQL to fetch Issues in scrum board Backlog and not part of Sprint
Use case
JQL to fetch issues from Backlog of Scrum board.
Solution
- Navigate to Board setting and fetch the Filter query.
- From Board filter query take all the conditions before Order By clause, if Filter query is like below, then copy only
project = XXX AND issuetype = XXX → (Board filter)
project = XXX AND issuetype = XXX ORDER BY Rank ASC
- The JQL below will fetch all the issues from Scrum Board Backlog
(Board filter) AND statusCategory != done and sprint is EMPTY
Note → If there is a issue which was part of a Sprint and at present the issue sprint is marked as completed however the issue was moved to Backlog wont be fetched. You will see the issue in Backlog however not from the JQL results.
Solution 2 : Exclude issues from active sprints.
To exclude issues from a specific sprint in Jira using JQL, you can use the NOT
operator along with the Sprint
field. For example, if you want to exclude issues from Sprint "Sprint 1", you can create a JQL query like this:
project = "Your Project Name" AND NOT Sprint = "Sprint 1"
Replace "Your Project Name"
with the actual name of your project. This query will retrieve all issues that are not in Sprint "Sprint 1." You can adjust the sprint name as needed to exclude issues from other sprints.
For multiple sprints :
To exclude issues that are part of multiple sprints in Jira using Jira Query Language (JQL), you can use the Sprint
field and negate it for each sprint you want to exclude. Here's the general format of the JQL query:
NOT (Sprint = "Sprint 1" OR Sprint = "Sprint 2" OR Sprint = "Sprint 3")
In this example, replace "Sprint 1," "Sprint 2," and "Sprint 3" with the names of the sprints you want to exclude. You can add as many sprints as needed by extending the OR Sprint = ...
part.
This query will exclude issues that are part of any of the specified sprints. If you want to exclude issues that are part of all the specified sprints (i.e., issues that are part of any of the specified sprints should be excluded), you can use the AND
operator instead of OR
in the query.
Please note that you should use the actual sprint names as they appear in your Jira instance. Also, be aware that Jira's JQL capabilities can vary based on your Jira version and any additional plugins or custom fields you have configured.