Changes

Jump to: navigation, search

SqlReports

1 byte removed, 12:08, 22 October 2022
sqlReports Examples
* [[Media:DemeritCount sqlReport.zip|Demerit Count]] - Reports active students in the current school and their demerit count based on the adoption of discipline_incidenttype field in log table as demerit field. You can modify query to suit your implementation of demerits.
* [[Media:YeartoYearEnrollmentComparison.zip|Year to Year Enrollment Comparison]] - Lets the user select two years to compare. Lists all enrollments from year 1 and then if they are enrolled or not in year 2.
**[[Media:SSO_Global_ID_Missing_Mismatched_sqlReport.txt.zip|sqlReport to find missing or mismatched Global IDs]] - Related to SSO via OIDC through Azure or Google. Unzip this file then open the txt contents and copy/paste in sqlReports setup to import this report that can help you keep your Global IDs up-to-date.
[[Category: Contents]]

Navigation menu