1.6.1

• Staff table was referencing wrong column for School ID causing no records to return.

1.6

Changes

• New Tables Added:

  • powerquery_table_districtcalendar
  • powerquery_table_schools

• Enhanced Connection Configuration:

  • Added filters to allow filtering of sections and terms by school year.

• Improved Staff Table Integration:

  • The Staff table now uses powerquery_table_schools for iteration, ensuring district-level staff are included.

Upgrade Notes

Upgrading to this version requires updates to your system configuration:

1. Update the PowerSchool Plugin:

   • Upgrade your PowerSchool plugin to the latest version to enable compatibility with the new tables.

2. Update System Connections:

   • If using the Staff table, include the new powerquery_table_schools table in your configuration.
   • If using Sections or Terms, re-save your system connection configuration to apply the new school-year filters.

Follow these steps to ensure a smooth upgrade to the latest version.

1.5.2

Additional Powerquery tables

• powerquery_table_terms
• powerquery_table_sections
• powerquery_table_cc
• powerquery_table_sectionteacher
• powerquery_table_students

1.5.1

• Added DOB and Gender to "powerquery_users"

1.5

• New: PowerQuery SchoolStaff
• New: PowerQuery Users

1.4.1

• Guardians table had wrong key and bad column name

1.4

• Added additional Custom PowerQuery tables
• Copied existing contacts tables into prefixed powerquery_ tables. Left existing tables for backward compatibility

1.3

• Added PowerQuery to return TeacherStatus

1.2

• New Contacts table that includes Addresses

1.1

• Added Configuration Tables