How the Hide unrelated sprints feature works on a Velocity Chart in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article is to briefly explain how the Hide unrelated sprints option from a Velocity Chart works. Velocity Chart is one of the reports available for boards on Jira through the Reports icon on the left menu.
Solution
Environment
Tested on 8.13.9 but should apply to all version since Velocity charts were introduced.
Explanation
When you enable the Hide unrelated sprints, the velocity chart will only show Sprints that were created from that board and this is determined by the origin board of a sprint.
If the sprint's origin board is the same as the board id then you should see in when the feature is enabled.
The id of the board can be seen when on the URL on your browser when accessing the board - it's the value in front of rapidView= .
There are two way to find the origin board of a sprint:
1. Through the database
1
select b."ID", b."NAME" as board_name, s."NAME" as sprint_Name from "AO_60DB71_SPRINT" s, "AO_60DB71_RAPIDVIEW" b where s."NAME" = '<SprintName>' and s."RAPID_VIEW_ID" = b."ID";2. Using REST API
A. If you have sprint id:
If you have the sprint id you may run go to this URL:
<JIRA_BASE_URL>/rest/agile/1.0/sprint/{sprint id}
The originboardid should be presented in the JSON.
B. If you don't have sprint id:
If you don't have the sprint id, go to a board where you can see the sprint and take note of the rapidView value:
<JIRA_BASE_URL/secure/RapidBoard.jspa?rapidView=XXXXXXX&view=reporting&chart=velocityChart
You'll use the numerical value of the rapidView on the next action.
Reach this address on your browser:
It will show all the Sprints for the board:
<JIRA_BASE_URL>/rest/agile/latest/board/XXXXXXX/sprint
There's also a currently open suggestion asking for an easy way to find that through the UI: JSWSERVER-13265 - Provide UI method to identify origin board for a sprint.
Was this helpful?