This is an automated email from the ASF dual-hosted git repository.
klesh pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 2094550ed fix(grafana): filter Jira sprint velocity by owning board
and time range (#9371)
2094550ed is described below
commit 2094550ed6998a58cf720672466900394b22467e
Author: Daniel Morfa Vega <[email protected]>
AuthorDate: Thu Nov 12 04:38:57 2026 +0100
fix(grafana): filter Jira sprint velocity by owning board and time range
(#9371)
The Sprint Velocity panel joined sprints with board_sprints only by
board_id, so it also showed sprints owned by other boards (Jira returns every
sprint any of the board's issues has been in) and ignored the dashboard time
range.
Only keep sprints whose original_board_id is the selected board and whose
completed_date is within the selected range.
Closes #9369
---
grafana/dashboards/mysql/Jira.json | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/grafana/dashboards/mysql/Jira.json
b/grafana/dashboards/mysql/Jira.json
index 62efb8c7a..82509f62b 100644
--- a/grafana/dashboards/mysql/Jira.json
+++ b/grafana/dashboards/mysql/Jira.json
@@ -1271,7 +1271,7 @@
"group": [],
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n s.name AS sprint,\n s.committed_story_point AS
'Committed',\n s.completed_story_point AS 'Completed'\nFROM sprints s\n JOIN
board_sprints bs ON bs.sprint_id = s.id\nWHERE\n bs.board_id in
(${board_id})\n AND s.committed_story_point is not null\nORDER BY
s.completed_date asc",
+ "rawSql": "SELECT\n s.name AS sprint,\n s.committed_story_point AS
'Committed',\n s.completed_story_point AS 'Completed'\nFROM sprints s\n JOIN
board_sprints bs ON bs.sprint_id = s.id\nWHERE\n bs.board_id in
(${board_id})\n AND s.original_board_id = bs.board_id\n AND
s.committed_story_point is not null\n AND
$__timeFilter(s.completed_date)\nORDER BY s.completed_date asc",
"refId": "A",
"select": [
[