maintenance · v1 · Head of Maintenance
431
tickets at Mon 20:00
SLA ended in the period, not cancelled, attended at or before due_at.
maintenance · changed 2026-11-01: First version.
Tests
- count_between min 100.0 max 800.0
SQL
SELECT id AS ticket_id, building_id, priority, due_at, attended_at, vendor_id
FROM tickets
WHERE due_at >= {period_start} AND due_at < {period_end} AND due_at <= {now} AND status <> 'cancelled'
AND attended_at IS NOT NULL AND attended_at <= due_at
ORDER BY due_at, id