Classroom Daily Bus Notes ~[tlist_sql;
SELECT sec.course_number, sec.section_number,
(SELECT listagg(max(p.abbreviation),'-')
WITHIN GROUP(ORDER BY p.abbreviation)
FROM section_meeting sm
JOIN period p ON p.period_number = sm.period_number AND p.year_id = sm.year_id AND p.schoolid = sm.schoolid
WHERE sm.sectionid = sec.ID
GROUP BY p.abbreviation) Period
FROM sections sec
where sec.id =~[gpv:sectionid];]
~(course_number).~(section_number) Period: ~(period)
[/tlist_sql]
Student Name
Add
Today's Notes
~[tlist_sql;
SELECT
s.lastfirst,
s.dcid,
replace(LISTAGG(chr(60) || 'a href="editBusNote.html?frn=001' || bn.studentsdcid || chr(38) || 'authId=' || bn.id || '" class="button"'
|| chr(62) || 'Edit' || chr(60) || '/a' || chr(62) || ' ' || bn.note || ' | Ends' || chr(58) || to_char(bn.end_date,'mm/dd/yyyy')
|| chr(60) || 'br' || chr(62)) WITHIN GROUP (ORDER BY bn.end_date), chr(60) || 'a href="editBusNote.html?frn=001~()' || chr(38) || 'authId=~()" class="button"'
|| chr(62) || 'Edit' || chr(60) || '/a' || chr(62) || ' | Ends' || chr(58) || chr(60) || 'br' || chr(62), '') AS prev_notes
FROM
Students s
JOIN CC ON s.id = cc.studentid
JOIN sections sec ON cc.sectionid = sec.id
LEFT OUTER JOIN u_bus_notes bn ON s.dcid = bn.studentsdcid AND trunc(sysdate) BETWEEN start_date AND end_date
WHERE
sec.id = ~[gpv:sectionid]
AND s.enroll_status = 0
GROUP BY s.lastfirst,s.dcid
ORDER BY s.lastfirst
;alternatecolor]