- Shipped
- August 13, 2026 at 2:36 AM UTC
- Author
- Kamo
- Commit
- b29033e
getTickets now bulk-loads an unseen-message count per row for the caller, beside the visitor rows it already loads that way, and getTicketDetail computes its own before the reader's markAsRead lands — so the window can show what arrived while they were away rather than a number the act of opening it already zeroed. Also closes the signal gap that left the queue stale. A message in a support conversation moves the queue for every support-capable member of the org, not only the people in that session — which is exactly who the per-session unread topic does NOT reach. The pending-count broadcast already fired when a public-chat visitor sent and when an agent marked read; a member replying from inside the app was the hole, so an in-app support conversation could gain messages with nothing telling any agent's screen to look again. SupportUnseenCountSqlTest pins the query's shape. Every clause in it is load-bearing and none of them is visible in a passing build: get one wrong and the queue still renders, just with counts that are quietly false.