• ~(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]