Hi all,
We noticed what appears to be a misleading label in the Attendance Trends report (report_graph_byType.php).
The filter dropdown is labelled “Class Group” in the UI, but the underlying SQL query pulls from gibbonFormGroup, not gibbonCourseClass:
SELECT gibbonFormGroupID as value, name FROM gibbonFormGroup
WHERE gibbonSchoolYearID=:gibbonSchoolYearID ORDER BY LENGTH(name), name
The selected values are then passed to queryAttendanceCountsByType which filters gibbonAttendanceLogPerson by gibbonFormGroupID.
Since class-based attendance (Attendance by Class) stores records with gibbonFormGroupID = NULL, the Attendance Trends report returns zero data for schools that use class-based attendance exclusively.
For schools that rely on Attendance by Class rather than Attendance by Form Group, none of the attendance overview reports produce useful data, as they all appear to depend on gibbonFormGroupID being populated.
Suggested fix: Either rename the filter label to “Form Group” to accurately reflect what it filters, or extend the report to support filtering by Course Class using gibbonCourseClassID which, in our case, would be preferred.
We are running Gibbon v30.0.01. Happy to provide more detail or test a fix.
Thanks!