What is the easiest way to take a list of rooms and figure out what sections are in those rooms?
That was the question that I had to answer this week.
In this instance, I had all of the sections defined in ManageBac, but the rooms being stored in PowerSchool. How could I combine those two things? Well here’s what I came up with.
The query was structured to grab all of the rooms and all of the sections in those rooms, then compare expressions against all of the section expressions in the database. With GraphQL tying all of these endpoints together i came up with a nice little report.
Since, only certain rooms would have to accommodate moves, the room selections had to be dynamic.
Future improvements would be:
1) to make it interactive. when you select an available room it removes that room from the availability of the other rooms.
2) following the logic of my first improvement, it should generate a final report just listing all of the sections and where they are moving.
3) create this as a dynamic page plugin directly onto PowerSchool instead of just a static report generated in PDF.