pf_app
Go to file
Paul Trowbridge 1df37a5ff1 Refactor sources UI, rename pf_ system cols, replace filter builder with raw SQL
- Sources page: left column with stacked DB tables + registered sources panels,
  right column as full-height column mapping workbench
- Add compact table search, column search, table preview button, delete source button
- Rename fc_table system columns to pf_ prefix (pf_id, pf_iter, pf_logid,
  pf_created_at) to avoid collisions with source table columns like 'id'
- Remove 'filter' col_meta role — any non-ignore column usable in baseline filters
- Replace structured filter row builder with free-form SQL WHERE clause textarea
  and clickable column chips for insertion; fully flexible AND/OR logic
- Baseline segment cards now display raw WHERE clause text + offset

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-04-03 00:47:57 -04:00
lib Refactor sources UI, rename pf_ system cols, replace filter builder with raw SQL 2026-04-03 00:47:57 -04:00
public Refactor sources UI, rename pf_ system cols, replace filter builder with raw SQL 2026-04-03 00:47:57 -04:00
routes Refactor sources UI, rename pf_ system cols, replace filter builder with raw SQL 2026-04-03 00:47:57 -04:00
setup_sql Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
.env.example Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
.gitignore Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
install.sh Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
package-lock.json Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
package.json Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
pf_spec.md Fix baseline request body in spec — unified filters array 2026-04-01 13:15:17 -04:00
server.js Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00