▣ wi

Pluto 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

Sub-items

Questions

Event log

• 2026-06-10T05:12:03.981Z · created · wi-cli-venus
• 2026-06-10T05:20:44.820Z · commented · wi-cli-venus
  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.