[Bug][Grafana] Work Log / Code Commits panel error

[mcseemz]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

invalid number of commits per user in Code Commits panel, Work Logs dashboard, when user has multiple accounts and his email does not match the one in GitHub.

What do you expect to happen

original sql

with _accounts as (
  select ua.account_id, ua.user_id, u.name, u.email
    from accounts a 
    join user_accounts ua on a.id = ua.account_id
    join users u on ua.user_id = u.id
  where ua.user_id in (${users:singlequote})
)

SELECT  count(distinct c.sha)
FROM commits c
join _accounts a on c.author_id = a.email
where $__timeFilter(authored_date)

proper sql

with _accounts as (
  select ua.account_id, ua.user_id, u.name, a.email <------ should be account email, not user email
    from accounts a 
    join user_accounts ua on a.id = ua.account_id
    join users u on ua.user_id = u.id
  where ua.user_id in (${users:singlequote})
)

SELECT  count(distinct c.sha)
FROM commits c
join _accounts a on c.author_id = a.email
where $__timeFilter(authored_date)

How to reproduce

create teams and users with user email not equal to his Github email, open panel and observe 0 commits.

Anything else

No response

Version

v1.0.3-beta10@99376a8

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[dosubot]

The bug analysis looks correct. The _accounts CTE in the "Code Commits" panel selects u.email from the users table, but the outer query joins on c.author_id = a.email — so when a user's DevLake user email differs from their GitHub account email, the join fails and returns 0 commits [1].

Interestingly, other panels in the same dashboard (e.g., "Lines of code") use c.author_id = a.account_id instead of an email-based join [2], which avoids this issue entirely. The fix proposed here — changing u.email to a.email in the CTE — should resolve the mismatch.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}