Technical notes on web development, DevOps, and AI integration.
1 article
The counter said 12, the table said 15: the date filter was reading the wrong clock. The fix counts from transition history, not the status column.
TL;DR: The dashboard showed mismatched ticket counts because one query filtered by creation date while the other reflected actual status changes today. Tickets created yesterday but handled today were missed due to timezone and date-boundary quirks in PostgreSQL. Switching all counters to aggregate the transition history by changed_at made the numbers consistent and trustworthy.