Keysproperty operations Corbelstone Residential

Ticket in SLA

Tickets whose vendor attended inside the attendance SLA (emergency 4 hours, urgent 24, routine 120), among the tickets whose SLA ended in the period.

Definition
in_sla

Params: none · evaluated at Mon 20:00

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