Sprints Table Reference
Sprints Table Description
The Sprints table is designed to export data related to sprints, including information such as the number of issues, estimations, and more. The specific list of fields that can be exported, along with their descriptions is presented in the table below.
Column Name | Column ID | Description |
Sprint ID | SPRINT_ID | Sprint unique ID in Jira database |
Sprint Name | SPRINT_NAME | Sprint name |
Sprint State | SPRINT_STATE | Sprint state (future, active, closed) |
Sprint Goal | SPRINT_GOAL | User-specified sprint goal This field is available for unloading on Jira versions 7.2.0 and higher. |
Sprint Activated Date | SPRINT_ACTIVATED_DATE | Actual start time of sprint in UTC This field is available for unloading on Jira versions 8.7.0 and higher. |
Sprint Complete Date | SPRINT_COMPLETE_DATE | Actual time of sprint completion in UTC |
Sprint Start Date | SPRINT_START_DATE | Sprint start time specified by user in UTC |
Sprint End Date | SPRINT_END_DATE | Sprint completion time specified by user in UTC |
Story Points Committed deprecated Note: The field was deprecated after 10/15/2023. | SPRINT_STORY_POINTS_COMMITTED | Overall assessment of Issues (exclude subtasks) in Story Points that were added to the sprint and were not closed before they were added. |
Story Points Completed deprecated Note: The field was deprecated after 10/15/2023. | SPRINT_STORY_POINTS_COMPLETED | Overall assessment of Issues (exclude subtasks) in Story Points that were added to the sprint and closed during sprint. |
Story Points Remaining deprecated Note: The field was deprecated after 10/15/2023. | SPRINT_STORY_POINTS_REMAINING | Difference between Committed and Completed fields values |
Issue Sprints Count | ISSUE_SPRINTS_COUNT | Number of Issues (tasks and subtasks) related to sprint |
Data used for calculation of Sprints table fields values
The table indicates the sources of data for calculating Sprints table fields.
Boards data and related data are not used in the process of calculating Sprints table field values. Thus, data presented on Boards may not match with the data obtained when calculating Story Points Committed and Story Points Completed field values of the Sprints table.
Column Name | Sources of data |
Sprint ID | Sprints table data |
Sprint Name | Sprints table data |
Sprint State | Sprints table data |
Sprint Goal | Sprints table data |
Sprint Activated Date | Sprints table data |
Sprint Complete Date | Sprints table data |
Sprint Start Date | Sprints table data |
Sprint End Date | Sprints table data |
Story Points Committed | Sprints table data Issue history changes (sprints, estimation field, resolution changes) Actual Issues Estimation Values Actual Issues Sprints Values |
Story Points Completed | Sprints table data Issues history changes (sprints, estimation field, resolution changes) Actual Issues Estimation Values Actual Issues Sprints Values |
Story Points Remaining | Story Points Committed field value Story Points Completed field value |
Issue Sprints Count | Actual Issues Sprints Values Issues and issues links data |
Calculation of Story Points Committed and Story Points Completed fields values
The custom numeric field for calculating determined by the corresponding mapping in the admin panel.
Field values are calculated by analyzing the history of changes in the state of each individual Issue relative to the start and completion dates of the corresponding sprint.
The history of changes for each Issue is tracked in the History tab.
To calculate the values, all Issues associated with a specific sprint are used.
NOTE: issues can be found in various projects and boards.
In order to see the current list of Issues for a specific sprint, use “Search for Issues” by Sprint value.
Issue status is determined by the presence of a value in the Resolution field. If the value is not empty, status is defined as "closed".
Calculating Story Points Committed and Completed fields values
Values that are included or excluded from the resulting Committed and Completed fields values are described in the Tables below
Values that are included or excluded from the resulting Committed field value
Sprint State | Include estimation field values | Exclude estimation field values |
Future | Opened Issues Actual Values | Closed Issues Values |
Active | Opened Issues Actual Values, Actual Values of Issues that closed in Sprint | Values of Issues that closed outside of sprint |
Closed | Opened Issues Values at the completion date of sprint, Closed Issues Values at the completion date of sprint | Values of Issues that closed outside of sprint |
Values that are included or excluded from the resulting Completed field value
Sprint State | Include estimation field values | Exclude estimation field values |
Future |
| |
Active | Actual Values of Issues that closed in Sprint |
|
Closed | Closed Issues Values at the completion date of sprint |
|