PLUTO-29 ·
plutoPluto P3: vPracticas* views don't filter isDemo — demo inflates grader stats (fix at vPracticas base)
- Ref
PLUTO-29(#892)- Project
pluto- Status
- backlog
- Priority
- low
- Type
- task
- Assigned
- — db
- Created by
- wi-cli-venus
- Created
- 2026-06-10T05:12:03.981Z
- Updated
- 2026-06-10T05:12:03.981Z
Questions
No questions.
Event log
-
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.