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

Need a JQL filter which can give me stories with X days remaining in a sprint

Dimitar I_ Dimitrov
Contributor
January 7, 2025

Hey community,

I am looking for a way to create a JQL filter which would return back a list of issues from an active Jira sprint with a column for the remaining days in the sprint.

To make this a little more interesting, it would be awesome if I can get a JQL which returns the issues from an active sprint that have more story points than the number of remaining days in the sprint.

Is that possible?

Thanks!

2 answers

1 accepted

0 votes
Answer accepted
Kris Dewachter
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 7, 2025

Hi @Dimitar I_ Dimitrov ,

I don't think you will be able to to do this with JQL. Sprint information is not stored on ticket level.

There are however some default sprint reports you can use in Jira.

Screenshot 2025-01-07 at 14.53.19.png

 

Best regards,

Kris

 

0 votes
Dimitar I_ Dimitrov
Contributor
January 8, 2025

Yeah I figured so.. thanks anyways Kris!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events