Keysproperty operations Corbelstone Residential

Open ticket

A maintenance ticket opened and not yet closed, merged or cancelled at the time asked.

Definition
open_ticket

Params: none · evaluated at Mon 20:00

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