For finding issues that spill over from one sprint to next, I tried this JQL posted by a user, but it did not work for me
project = name AND Sprint in openSprints() AND Sprint in closedSprints()
When you close a Sprint in Jira Software, the stories you didn't finish are either marked as done in the closed Sprint, or moved to another Sprint.
An issue can't be in 2 different sprints. As a result, your issues are either in a closed Sprint, or in a new one, which explains why your query doesn't return anything.
You should try either project = name AND Sprint in openSprints(), or project = name AND Sprint in closedSprints()
Let me know if it helped,
Hi @pmeghrajani -- Welcome to the Atlassian Community!
The query you noted works after the current sprint has started. If it has not yet started, please try:
project = myProjectName AND sprint IN futureSprints() AND sprint IN closedSprints()
The sprint field is a list, so it will contain all of the sprints which an issue has been in, with one exception: if you put an issue in a future sprint and then remove it before it starts, the sprint value is removed.
Hello Community! My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event