Brings CRQ to FleetOps-dashboard parity with INC for the Tickets tab's CRQ sub-tab:
- 16_crq_dashboard.sql: tickets.crq_open_sla view (mirror of inc_open_sla, no geog;
lat/lng from geom) + reporting.fn_crq_dashboard / fn_crq_search / fn_crq_filter_options
(mirrors of the inc functions over tickets.crq) + grants to dashboard_ro/grafana_ro.
- Recover the previously un-versioned 13_inc_search_fn.sql + 14_inc_filter_options.sql
into the repo (verbatim from the live defs) so a fresh DB rebuilds faithfully; the
live ledger already lists them so run_migrations skips them there.
Consumed by dashboard_api GET /webhook/crq-dashboard|crq-search|crq-filter-options.
Not yet applied to prod (pending go-ahead).
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
c980f3edd0