Sprint Start Issues don't show in JQL query?

[Bud Herz]

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. 

[Alexey Pavlenko _App Developer_]

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.

• 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

[Sahir Maharaj]

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.