dmorfav opened a new pull request, #9371:
URL: https://github.com/apache/devlake/pull/9371

   ### Summary
   
   Fixes the **Sprint Velocity: Committed vs Completed Story Points [Closed 
Sprints]** panel of the Jira dashboard (`grafana/dashboards/mysql/Jira.json`).
   
   The panel joined `sprints` with `board_sprints` only by `board_id`. The Jira 
Agile API returns, for a board, every sprint any of its issues has ever been 
in, so the panel also plotted sprints owned by other boards. It also had no 
`$__timeFilter`, so every historical sprint was shown regardless of the 
selected range. On long-lived boards this made the chart unreadable.
   
   This PR adds two conditions to the panel query:
   
   ```sql
   AND s.original_board_id = bs.board_id
   AND $__timeFilter(s.completed_date)
   ```
   
   Verified on v1.0.3-beta19 against a real Jira board: before, the panel mixed 
sprints from several unrelated boards going back years; after, it shows only 
the board's own closed sprints within the selected range. No other panels are 
touched.
   
   ### Does this close any open issues?
   
   Closes #9369
   
   ### Screenshots
   
   Not included, as they contain internal sprint names. Happy to describe the 
before/after in more detail if needed.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to