Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to find spilled over items per sprint

sujit Sadanand dhaygude
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 24, 2022

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 Champion
August 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
Product Admin
TAGS
AUG Leaders

Atlassian Community Events