Inactive Guardian Query appears to have wrong schools

American-School-of-the-Hague / psd2l-plugin

PowerQueries for PowerSchool SIS for use with Data Export Manager (DEM)

GNU General Public License v3.0

3 stars 3 forks source link

Inactive Guardian Query appears to have wrong schools #35

Open txoof opened 11 months ago

txoof commented 11 months ago

In lines 70-72 in the guardian inactive query, it appears that only HS is being counted.

This should also check MS (schoolid = 2)

                    WHERE yearid = (SELECT MAX(yearid) FROM terms WHERE schoolid = 3 AND MOD(id, 100) = 0)
                    AND schoolid = 3
                    AND MOD(id, 100) = 0