Hello,
I have found a code so that Daily Attendance is visible to teachers in the Daily Bulletin, but it does not seem to be showing up. We used to have the Attendance (absences, latenesses, etc) appear in the Daily Bulletin in real time. The person who used to do this, has since left the district and we are trying to figure this out.
Do I need to wait until the school year starts in order to see if it works?
The code I found is below:
Student
Current Grade Level
Attendance Date
Code
~[tlist_sql;
SELECT
s.lastfirst,
s.grade_level,
att.att_date,
ac.att_code
FROM attendance att
INNER JOIN attendance_code ac ON att.attendance_codeid = ac.ID
left outer JOIN attendance_time attt on attt.attendanceid = att.id
INNER JOIN students s on att.studentid = s.id
WHERE att.att_date='~[bulletindate;0]'
AND att.yearid=22
AND att.att_mode_code='ATT_ModeMeeting'
AND ac.att_code is not null
AND att.schoolid=2
ORDER BY s.lastfirst,att.Att_Date;alternatecolor]
~(s.lastfirst;t)
~(s.grade_level;l)
~(att.att_date;d)
~(ac.att_code;t)
[/tlist_sql]
Legend
Attendance Codes: ~[x:att_code_legend;if.blank.then=Blank]
Thank You,
