maintenance · v1 · Head of Maintenance
209
tickets at Mon 20:00
opened_at before now and closed_at empty or after now.
maintenance · changed 2026-11-01: First version.
Tests
- count_between min 20.0 max 800.0
SQL
SELECT id AS ticket_id, building_id, unit_id, category, priority, opened_at, due_at
FROM tickets WHERE opened_at <= {now} AND (closed_at IS NULL OR closed_at > {now})
ORDER BY opened_at, id