Sprint Start Issues don't show in JQL query?

Question

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_ · Answer

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_28wu8p · Answer

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.