Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I find issues which were moved out from a sprint

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()

2 answers

0 votes
Guilhem Dupuy Community Leader Nov 19, 2020

Hello,

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,

Guilhem

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.

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Trello

📹 Favorite Trello templates

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 ...

99 views 5 7
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you