- Shipped
- September 7, 2026 at 10:51 PM UTC
- Author
- Kamo
- Commit
- cc7a0cd
Adds an optional reporterId predicate to findVisible (both halves) and to countGroupedByStatus, so the numbers beside the status menu keep promising what picking a status would actually show. It filters on b.reporter.id and never on b.reporterOrg — the second would be the tenancy predicate this query is required not to have, wearing a different name. Adds the directory behind the filter's picker: everybody who has filed at least one report the viewer can see, with how many. Two queries rather than one, both applying the listing's publish and voided rules verbatim — a name the filter offers that the list cannot produce a row for reads as a broken filter. Deliberately a query and not a maintained table. A denormalised "who has reported something" table has to be kept in step with every create, void and delete, and its failure mode is silent: a reporter missing from the filter looks exactly like a reporter with nothing to their name. The table it groups over grows by one row per bug somebody sat down and wrote — 87 of them across the estate as this shipped. If it ever stops being free the answer is an index on reporter_id, not a second source of truth.