KB-3770

S149 Step 3 — VIEW_MAP Removed

1 min read Revision 1
s149pivotstep3viewmap

S149 Step 3 — Remove VIEW_MAP Hardcode Report

Agent: Claude Code CLI Ngày: 2026-03-30 PR: #652 (MERGED + DEPLOYED)

Fix

  • Removed hardcoded VIEW_MAP (3 entries: PIV-101, PIV-103, PIV-104)
  • Replaced with dynamic read from pivot_results table
  • pivot_results populated by refresh_pivot_results() cron every 10 min
  • All 32 active pivots now served dynamically

Verify Production

  • PIV-101 (regression): 7 rows ✅ (was in VIEW_MAP, still works)
  • PIV-201 (new L2 atom): 14 species groups ✅ (was NOT in VIEW_MAP, now works)
  • grep VIEW_MAP: 0 hardcode references ✅
  • Deploy: SUCCESS ✅

Tuyên ngôn

INSERT pivot_definitions → refresh_pivot_results cron → API auto-serves. KHÔNG sửa code. ✅

TD-437: RESOLVED