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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
