[PR] fix(grafana): use account email in Work Logs "Code commits" panel to fix 0-commit count for users with multiple accounts [devlake]

["bujjibabukatta (via GitHub)" <gi...@apache.org>]

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

   Fixes #8833
   
   ## Problem
   The "Code commits" panel in the Work Logs dashboard shows 0 commits when
   a user's DevLake profile email differs from their GitHub account email.
   
   ## Cause
   The `_accounts` CTE was selecting `u.email` (DevLake user email) but the
   join used `c.author_id = a.email` which expects the GitHub account email.
   
   ## Fix
   Changed `u.email` to `a.email` in the `_accounts` CTE so it correctly
   uses the account email when matching commits.
   
   ## Files Changed
   - `grafana/dashboards/mysql/work-logs.json`
   - `grafana/dashboards/postgresql/work-logs.json`


-- 
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: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [PR] fix(grafana): use account email in Work Logs "Code commits" panel to fix 0-commit count for users with multiple accounts [devlake]

["Startrekzky (via GitHub)" <gi...@apache.org>]

Startrekzky merged PR #8925:
URL: https://github.com/apache/devlake/pull/8925


-- 
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: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org