Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

how to find spilled over items per sprint

Sprint in openSprints() and project = "Infinity Process Platform" AND Sprint in closedSprints() did not work - for jira instance

1 answer

1 vote
Jack Brickey Community Leader Aug 24, 2022

One thing to be aware of here is that JQL would only find issues if the sprint field consisted of at least one closed Sprint and an active sprint. Depending on how you define"Spilled over" this could be flawed; consider if an issue has more than one closed sprint and no open sprint. 

in any event I found this JQL to work for me...

Sprint in openSprints() and sprint in closedSprints()

You might also consider the following JQL which would find any issues not yet complete that have associated closed Sprint...

sprint in closedSprints() and resolution is EMPTY

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

5,078 views 18 32
Read article

Atlassian Community Events