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]
