david kiania 73c5f31f97 feat(reporting): fn_inc_filter_options for explorer dropdowns (migration 14) ... Distinct engineers (owner, case-normalized), distinct clusters, and currently-open ticket ids — feeds the ticket-explorer pulldowns. Backs GET /webhook/inc-filter-options. Validated: 74 owners, 43 clusters, 489 open ids. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>		2026-06-19 12:34:43 +03:00
..
01_tickets_schema.sql	feat: fleettickets — INC/CRQ ticket ingestion, geocoding + read-schema	2026-06-11 20:13:50 +03:00
02_import_meta.sql	feat: INC hourly-CSV ingestion (newest-file, ETag dedup, clean + archive)	2026-06-15 19:33:16 +03:00
03_inc_columns.sql	fix: address valid findings from 20260618 bug report	2026-06-18 13:41:38 +03:00
04_inc_latlng.sql	feat: populate inc latitude/longitude from geocoded geom (migration 04)	2026-06-15 23:26:39 +03:00
05_inc_geography.sql	feat: add geography column + GiST index for routing (migration 05)	2026-06-15 23:33:45 +03:00
06_inc_mttr_minutes.sql	feat: mttr -> minutes; drop constant alarm/auto flags (migration 06)	2026-06-15 23:51:28 +03:00
07_inc_drop_service_type.sql	feat: drop constant service_type column (migration 07)	2026-06-15 23:54:43 +03:00
08_inc_open_sla_view.sql	feat: tickets.inc_open_sla view + lowercase legacy region	2026-06-16 00:03:55 +03:00
09_inc_dashboard_fn.sql	feat: reporting.fn_inc_dashboard — INC operations dashboard read-API (migration 09)	2026-06-16 01:10:18 +03:00
10_inc_history_capture.sql	feat: history capture — closure_events + daily backlog snapshot (migration 10)	2026-06-16 01:19:23 +03:00
12_inc_dashboard_by_owner.sql	feat(reporting): add closure-by-engineer analytics to fn_inc_dashboard (migration 12)	2026-06-18 17:53:32 +03:00
13_inc_search_fn.sql	feat(reporting): fn_inc_search for the ticket explorer (migration 13)	2026-06-19 11:48:22 +03:00
14_inc_filter_options.sql	feat(reporting): fn_inc_filter_options for explorer dropdowns (migration 14)	2026-06-19 12:34:43 +03:00