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": [
             [

Reply via email to