nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to Query (JQL) issues not in the current sprint?

Sebastian Toplician_l0oju6

I'm trying to look for a way to write a query that will tell me what issues are not part of the current sprint, but assigned to specific individuals.

Query example I have below is:

project = REVOPS AND status in ("In Progress", "In Review", "Needs Refinement", On-Hold, "Pending Outside Postman", "Pending Triage", "Pending with Other Team", "Ready to Deploy", "To Do", "Under Review") AND assignee in (624a774ded4d6b00701588b6) OR "Additional Assignees[User Picker (multiple users)]" in (624a774ded4d6b00701588b6) AND Sprint not in openSprints() ORDER BY cf[10006] ASC, created DESC

I found a few links to help https://community.atlassian.com/t5/Jira-questions/How-to-find-all-issues-not-in-a-sprint/qaq-p/1391047, but the openSprints, closed and future aren't displaying correct results for me. For example I am seeing issues that are in our current sprint when using the "Sprint not in openSprints().

I am still getting results for issues that are in our current active sprint for the project I am querying against. Really not sure how to update it.

If anyone can lead me in the right direction please.

Accepted answers

Bill Sheboy

Hi @Sebastian Toplician -- Welcome to the Atlassian Community!

When writing a query, the order of operations is important. The clauses with AND occur before OR, so I suspect you are running into that.

Based on what you described, perhaps try the one below, which I reformatted for easier reading and wrapped any OR clauses with parentheses to enforce the order you noted.

project = REVOPS
 AND status IN ("In Progress", "In Review", "Needs Refinement", On-Hold, "Pending Outside Postman", "Pending Triage", "Pending with Other Team", "Ready to Deploy", "To Do", "Under Review")
 AND (
       assignee IN (624a774ded4d6b00701588b6)
       OR "Additional Assignees[User Picker (multiple users)]" IN (624a774ded4d6b00701588b6)
     )
 AND Sprint NOT IN openSprints()
 ORDER BY cf[10006] ASC, created DESC

To learn more about JQL, please see this free online training provided by Atlassian:

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

All comments

Mybpcreditcard

Can you attach a screenshot of the Issue Navigator icon next to the backlog?

mybpcreditcard

Bill Sheboy

Hi @Sebastian Toplician -- Welcome to the Atlassian Community!

When writing a query, the order of operations is important. The clauses with AND occur before OR, so I suspect you are running into that.

Based on what you described, perhaps try the one below, which I reformatted for easier reading and wrapped any OR clauses with parentheses to enforce the order you noted.

project = REVOPS
 AND status IN ("In Progress", "In Review", "Needs Refinement", On-Hold, "Pending Outside Postman", "Pending Triage", "Pending with Other Team", "Ready to Deploy", "To Do", "Under Review")
 AND (
       assignee IN (624a774ded4d6b00701588b6)
       OR "Additional Assignees[User Picker (multiple users)]" IN (624a774ded4d6b00701588b6)
     )
 AND Sprint NOT IN openSprints()
 ORDER BY cf[10006] ASC, created DESC