KamoCRM

The disclosure ledger query service — keyset pages on one index per filter, the member union, labels and counts (KamoCollab CP08 T6)

FeatureSecurityService
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.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing