Export a Report Through One Cursor
Separate all-rows XLSX export from page queries: consume one result cursor, preserve permissions and cell conversion, stage the file, and verify failure cleanup.
TYPECategories
Backend
6 articles
Add Event Detail Without Inventing History
Evolve aggregate-only counters into an event log by writing details and totals atomically, preserving irreducible legacy summaries, and using stable cursor pagination.
Keep Batch Deletes Inside the Persistence Boundary
Repair a batch deletion path that depended on a read projection by loading persistence models directly, validating the full batch, and returning the real transaction result.
Fixing Today-Only Metrics with Explicit Day Boundaries
Repair a metric labelled today that included the previous day by defining one local-day interval, isolating headline parameters, and reconciling the total with its detail population.
Deriving Workflow Status from Real Transition Evidence
Repair a workflow report that advances too early by filtering invalid events, normalizing legacy stages, recovering from business evidence, and recording milestones only when transitions occur.
Filter Before You Rank and Aggregate: Taking a 27-Second Query Down to About One Second
How moving selective business filters ahead of window functions and dependent aggregates cut a paginated Oracle query from 27.49 seconds to about 1.40 seconds.