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

Sprint Start Issues don't show in JQL query?

Bud Herz
Contributor
January 21, 2025 edited

Background:
Previous Sprint Burndown, lists a total of 60 points for all issues when Sprint start was triggered at 7:05pm 8/21/2024
Approximate total issue count easily over 20 (Bugs, Stories, Tasks)
Sprint ended 9/3/2024

Challenge:
JQL search for issues added to that Sprint within a generous date range (8/20 to 8/22) does not return the correct number of points. In fact it only returns 3 (bugs) listed in the Sprint Burndown 'Start' list. 

What am I missing?

JQL Query used:
project = FS

AND sprint = 281

AND "added to sprint[date]" >= "2024-08-20"

AND "added to sprint[date]" <= "2024-08-22"

ORDER BY cf[10005] ASC, cf[10958] ASC, Key ASC


My Quest:
I need to decipher -
 - Points at Sprint Start
 - Points added during a Sprint
 - Planned points not completed vs added points completed. 

2 answers

0 votes
Alexey Pavlenko _App Developer_
Atlassian Partner
January 21, 2025 edited

Hi @Bud Herz ,

Unfortunately, I do not completely understand the query since it seems you use some 3rd party extension for JQL, particularly for this clause:

added to sprint[date]

 

You request, unfortunately, is not possible to fullfill using native JIRA, but you can use the 3rd party app I developed for that -  Multi-team Scrum Metrics & Retrospective.

image.png image.png

 

  • for 'Points at Sprint Start' refer to the Initial Scope.
  • for 'Points added during a Sprint' refer to the Added Scope.
  • for 'Planned points not completed vs added points completed' there is no relevant comparison, but probably you can measure how much of the Uncompleted Scope is out of the Final Scope (or the Initial Scope, which can be configured).

Best regards,
Alexey

0 votes
Sahir Maharaj
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 21, 2025

Hello @Bud Herz

Based on my understanding, the JQL query you are using might not account for changes in issue history accurately.

Jira’s sprint-related fields like "Added to Sprint" require precise configurations and may miss data if not properly indexed.

I would recommend to consider using advanced JQL plugins or analyzing issue history through the API for more detailed results.

Suggest an answer

Log in or Sign up to answer
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