Ivo Oskamp
a919610d68
Critical bug: Same ticket appeared multiple times in popup (e.g., T20260127.0061 showed 8 times). Root Cause: The JOIN with ticket_scopes/remark_scopes created duplicate rows when a ticket had multiple scopes (Cartesian product). Changes: - Removed unnecessary JOIN ticket_scopes from tickets query - Removed unnecessary JOIN remark_scopes from remarks query - Added DISTINCT to prevent any duplicate rows - Changed COALESCE(ts.resolved_at, t.resolved_at) to t.resolved_at (ticket_scopes JOIN removed, only ticket resolution matters) Result: Each ticket/remark now appears exactly once in popup. Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com> |
||
|---|---|---|
| .. | ||
| architecture.md | ||
| autotask_rest_api.md | ||
| backupchecks_autotask_integration_functional_design_living_document.md | ||
| backupchecks_autotask_integration_implementation_breakdown.md | ||
| backupchecks_autotask_integration_phase_2_implementation.md | ||
| changelog-claude.md | ||
| changelog.md | ||
| manifest.md | ||
| migrations.md | ||
| reporting-proposal.md | ||