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
4,361,704
Community Members
 
Community Events
168
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 

 

https://jira.fis.dev/ - 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
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
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