- Shipped
- October 11, 2026 at 3:26 PM UTC
- Author
- Kamo
- Commit
- 18b1bac
DisclosureLedgerQueryService reads org_disclosure_events and its two child tables over NamedParameterJdbcTemplate. Each entry point builds one driving statement on one index (source > recipient > run > actor > decision > org time), with the org as the first predicate of every statement, ORDER BY occurred_at DESC, id DESC LIMIT size + 1, and the remaining filters as predicates. /member is the actor branch UNION the recipient branch, each bounded by its own limit. The page's recipients and sources are read by event_id IN (:ids), team and department titles in one batched read each. countsByDecision runs one range count per decision on ix_ode_org_decision; countReadOutcome counts the org's Tool Plane rows for one policy_decision on **************** (R1-19). DisclosureLedgercoder is base64url of <epoch micros>.<uuid>; DisclosureEventView is spec 5.4.4's item shape.
