(devlake) branch main updated: fix(grafana): use account email instead of user email in Work Logs Code Commits panel (#8925)

[zky]

This is an automated email from the ASF dual-hosted git repository.

Startrekzky 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 46c5c5106 fix(grafana): use account email instead of user email in 
Work Logs Code Commits panel (#8925)
46c5c5106 is described below

commit 46c5c5106cfd103614b7da0bc39c611e4481b7c0
Author: bujjibabukatta <bujjibabukat...@gmail.com>
AuthorDate: Tue Jun 16 20:53:42 2026 +0530

    fix(grafana): use account email instead of user email in Work Logs Code 
Commits panel (#8925)
    
    Co-authored-by: Louis.z <louis.s4372...@gmail.com>
---
 grafana/dashboards/mysql/work-logs.json      | 2 +-
 grafana/dashboards/postgresql/work-logs.json | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/grafana/dashboards/mysql/work-logs.json 
b/grafana/dashboards/mysql/work-logs.json
index ba2da4761..3c7b784ce 100644
--- a/grafana/dashboards/mysql/work-logs.json
+++ b/grafana/dashboards/mysql/work-logs.json
@@ -787,7 +787,7 @@
           "editorMode": "code",
           "format": "table",
           "rawQuery": true,
-          "rawSql": "with _accounts as (\n  select ua.account_id, ua.user_id, 
u.name, u.email\n    from accounts a \n    join user_accounts ua on a.id = 
ua.account_id\n    join users u on ua.user_id = u.id\n  where ua.user_id in 
($users)\n)\n\nSELECT  count(distinct c.sha)\nFROM commits c\njoin _accounts a 
on c.author_id = a.email\nwhere $__timeFilter(authored_date)\n",
+          "rawSql": "with _accounts as (\n  select ua.account_id, ua.user_id, 
u.name, a.email\n    from accounts a \n    join user_accounts ua on a.id = 
ua.account_id\n    join users u on ua.user_id = u.id\n  where ua.user_id in 
($users)\n)\n\nSELECT  count(distinct c.sha)\nFROM commits c\njoin _accounts a 
on c.author_id = a.email\nwhere $__timeFilter(authored_date)\n",
           "refId": "A",
           "sql": {
             "columns": [
diff --git a/grafana/dashboards/postgresql/work-logs.json 
b/grafana/dashboards/postgresql/work-logs.json
index 8ff5fabc6..779e43bb1 100644
--- a/grafana/dashboards/postgresql/work-logs.json
+++ b/grafana/dashboards/postgresql/work-logs.json
@@ -787,7 +787,7 @@
           "editorMode": "code",
           "format": "table",
           "rawQuery": true,
-          "rawSql": "WITH _accounts AS (SELECT ua.account_id, ua.user_id, 
u.name, u.email FROM accounts AS a JOIN user_accounts AS ua ON a.id = 
ua.account_id JOIN users AS u ON ua.user_id = u.id WHERE ('${users:csv}' = '' 
OR ua.user_id::text = ANY(ARRAY[${users:singlequote}]::text[]))) SELECT 
COUNT(DISTINCT c.sha) FROM commits AS c JOIN _accounts AS a ON c.author_id = 
a.email WHERE $__timeFilter(authored_date)",
+          "rawSql": "WITH _accounts AS (SELECT ua.account_id, ua.user_id, 
u.name, a.email FROM accounts AS a JOIN user_accounts AS ua ON a.id = 
ua.account_id JOIN users AS u ON ua.user_id = u.id WHERE ('${users:csv}' = '' 
OR ua.user_id::text = ANY(ARRAY[${users:singlequote}]::text[]))) SELECT 
COUNT(DISTINCT c.sha) FROM commits AS c JOIN _accounts AS a ON c.author_id = 
a.email WHERE $__timeFilter(authored_date)",
           "refId": "A",
           "sql": {
             "columns": [