- ~(current.final.grade.name) Classes
= Late Assignments
= Missing Assignments
~[tlist_sql;
SELECT
cc.dcid,
'~(current.final.grade.name)' fg,
sync_cc.sectionenrollmentid psmseid,
c.course_name, sec.expression,
(case when sum(NVL(psmas.ismissing,0)) > 0 then 'inline' ELSE 'none' END) missingicon,
(case when sum(NVL(psmas.turnedinlate,0)) > 0 then 'inline' ELSE 'none' END) lateicon
FROM CC
INNER JOIN SECTIONS sec on CC.sectionid = sec.id
INNER JOIN COURSES c on sec.course_number = c.course_number
INNER JOIN SYNC_SECTIONENROLLMENTMAP sync_cc on cc.dcid = sync_cc.ccdcid
LEFT OUTER JOIN PGAssignments PGA on cc.sectionid = pga.sectionid
LEFT OUTER JOIN SYNC_PGASSIGNMENTSMAP sync_pga on pga.dcid = sync_pga.pgassignmentsdcid
LEFT OUTER JOIN PSM_ASSIGNMENTSCORE PSMAS ON sync_pga.sectionassignmentid = psmas.sectionassignmentid and sync_cc.sectionenrollmentid = psmas.sectionenrollmentid
WHERE CC.studentid = ~(curstudid)
AND CC.dateenrolled <= trunc(sysdate) and cc.dateleft >= trunc(sysdate)
and ((pga.datedue >= (SELECT min(date1) from termbins where schoolid=~(curschoolid) and yearid = ~(curyearid) and upper(storecode) LIKE CASE WHEN '~(current.final.grade.name)' IS NULL THEN '%' ELSE upper('~(current.final.grade.name)') END )
and pga.datedue <= (SELECT max(date2) from termbins where schoolid=~(curschoolid) and yearid = ~(curyearid) and upper(storecode) LIKE CASE WHEN '~(current.final.grade.name)' IS NULL THEN '%' ELSE upper('~(current.final.grade.name)') END )) OR pga.datedue is null)
GROUP by cc.dcid,sync_cc.sectionenrollmentid, c.course_name, sec.expression
~[if.prefschool.mobileclasssort=classname]ORDER BY c.course_name, sec.expression
[else]ORDER BY sec.expression, c.course_name[/if]]
-
~(sec.expression;t;externalexpression) ~(c.course_name;t)
[/tlist_sql]