Class Attendance w/Meeting Attendance View

On the Meeting Attendance View page, here's one of the parts that finds total absences:

(SELECT count(*) FROM attendance att WHERE studentid=s.id AND ccid=cc.id AND attendance_codeid in (~(v.abscodes)) AND att_date >= '~(v.ddfirstday)' AND att_date <= '~(v.ddlastday)' AND att_mode_code = 'ATT_ModeMeeting') ddabscount

The v commands are page variables set at the top of the page which I used in different spots, but the one that has the absence codes is the ~(v.abscodes) one. You could replace that with sql to look up Excused and Unexcused codes by looking at the attendance code entity and code entity tables. You'd probably have to create those lists either as other select statements or a temporary variable because the page variables aren't very good at multiple table extractions like sql. Or you could type in the attendance code id's themselves within the parenthesis.

Sounds like your custom folders area is blank. Click on the Tips and How To's link on the left side of the site and go to the Customization Basics page. You can either let PS create all the custom folders for you or you can create them by hand.

Matt