Pluto P3: vPracticas* views don't filter isDemo — demo inflates grader stats (fix at vPracticas base)

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-10
• wi-cli-venus commented · 2026-06-10
  PLUTO-17 investigation details: 3 view chains missing isDemo guard beyond the 2 fixed in 010. 1. vPracticas base view (practicas WHERE deletedAt IS NULL, no isDemo filter) — fix here cascades to: vPracticasCompletas, vPracticasList, vPracticasHierarchyRollup, vPracticaParticipantFacts, vPracticasAuditEntries (5 downstream views inherit). 2. vStudentPracticaStats — queries studentAssignments sa side directly + joins vPracticas. Needs AND sa.isDemo IS NOT TRUE on the sa side even after vPracticas is fixed. 3. vPracticaLookups — joins practicaAnestesias/tecnicas sub-tables (practica children, no direct isDemo col). Inherits fix once vPracticas is filtered. 4. vInformesFilterOptions — teacher filter options from comisionAdjuntos, no student/demo data exposure. Closed as N/A per pm-pluto-cc decision PLUTO-17. Fix strategy: add AND isDemo IS NOT TRUE to vPracticas WHERE clause (studentAssignments.isDemo is nullable bool per live schema — use IS NOT TRUE not = false). Then fix vStudentPracticaStats sa side separately.