04 — /knowledge/pivot Page Audit (VERIFIED v2)

URL: https://vps.incomexsaigoncorp.vn/knowledge/pivot

What it is

Title "Pivot — Thống kê theo Lớp cấu tạo". Subtitle "PG tính, Directus serve, đây chỉ hiện" (PG computes, Directus serves, this only displays) — a textbook Đ26 MT8 / Đ28 render-shell statement.

Live rendered table (verbatim, WebFetch SSR)

Columns: Lớp / Phân loại / Tổng cá thể / Số loài / Mồ côi.

• Atoms 1,666,465 / 21 species · Molecules 774 / 11 · Compounds 423 / 8 · Materials 0 · Products 0 · Buildings 0
• Meta/Species 42 / 42 species / 1 orphan
• DOT Tools (meta): 307 / 0 / 140 orphan · Collections (meta): 168 / 0 / 20 orphan This is the Tab Pivot 9-row layout (Đ26 §II-BIS).

Data-source verdict

Cleanest surface in the system. Reads pivot_results via Directus (per KB reports s146-m4c, s149). No hardcoded counts in the displayed pivot table; render-only. Architecturally Đ26/Đ28-compliant.

Verified nuance on the DOT "307"

The page's "DOT Tools 307" comes from the CAT-DOT meta-row (record_count 307), NOT from the canonical pivot: live dot_tools=309 and fresh PIV-007=309 (refreshed 2026-05-30 13:27). So even the clean pivot page is, for the DOT meta-row, rendering a stale stored meta number (307) rather than the live pivot (309). → the inconsistency is a data-source-selection defect (CAT-DOT vs PIV-007), not a layout defect. Fixing it = point the DOT row at PIV-007.

Pivot results freshness (verified)

pivot_results: 126 rows, newest 2026-05-30 13:27, oldest 2026-05-11, 3 needs_refresh=true. refresh_pivot_results() runs but unevenly; a few rows lag.

Reusable assets (KEEP / canonicalize)

• The pivot page render-shell + Directus pivot_results fetch = the reference pattern for the rebuild.
• 9-row layer model + species + orphan columns.

Verdict: REUSE (canonical). Structure correct; the only fixes are operational — (a) DOT row should read PIV-007 not CAT-DOT, (b) surface refreshed_at, (c) clear the 3 needs_refresh rows.