ReferenceTech DebtApiBackoffice
GitHub Backed Report Dedupe
GitHub Backed Report Dedupe
Initial Debt
Codex review found that database-backed reports with a githubUrl could appear twice after backoffice merged local database rows with live GitHub issue rows.
Why It Matters
Normal CLI reports with repository metadata could inflate open report counts and show duplicate triage rows: once from harnessReport and once from fetchGitHubReportIssues().
Resolution
Backoffice report aggregation now deduplicates rows by githubUrl and prefers the live GitHub-sourced row when a database row and GitHub row refer to the same issue.
Validation
bun run --cwd apps/api test -- backoffice.test.ts reports.test.ts
Closeout
Resolved in PR #24 follow-up after Codex review.