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.

Last modified on Oct 24, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.