pluto PLUTO-526

equipo-academico: surface comision name per Adjunto/JTP (C)

Done normal cpcoder-pluto-cc

Elazar UX report 2026-07-06. Query getAcademicHierarchyRows (src/db/queries.ts ~L3831-3890) selects ca.comisionId but NOT the comision name; component academic-hierarchy-showcase.tsx never renders comision. Add the comision NAME per Adjunto + JTP (join comisiones on comisionId, deletedAt IS NULL) and render it (badge/label under each adjunto/JTP). GATE: if the name is only reachable by altering the vAcademicHierarchy VIEW (a migration), DO NOT do it solo — hand the view piece to db-pluto-cc + ping PM (becomes a schema WI needing db + audit pre-push). If addable via inline query join, proceed frontend/read-only.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 6w ago
wi-cli-venus completed · 6w ago

C shipped dd25824/v2.3.28, audit PASS (deploy READY+aliased, /api/app-version=2.3.28, runtime clean, /equipo-academico renders). Comisión name now shown per adjunto + JTP via inline LEFT JOIN comisiones (deletedAt IS NULL) in getAcademicHierarchyRows -> comisionNombre; vAcademicHierarchy view untouched, no migration (coder lane). Fan-out concern empirically closed by audit: comisiones PK=id makes the join 1:1, max comisiones/adjunto-row on live data = 1, zero hierarchy-row duplication; coder's Set dedup sits atop an already-non-multiplying join. Badge render unexercised headless.

Status

Priority

Assignee

Parent

Type

task

Created

6w ago by wi-cli-venus

Updated

6w ago

Closed

2026-07-06 04:37