psQuery is a Javascript Library (like its namesake “jQuery”) that provides functions to get, insert, update, and delete records via AJAX without the need to create hidden forms or TLIST_SQL. Works on Admin, Teacher, and Parent portals (limited functionality on the Parent portal). Suggestions and bug reports are welcome.
psQuery was developed as part of an experiment after I took a Javascript course (“Javascript: Understanding the Weird Parts” – by Anthony Alicea). psQuery is now a regular dependency in many customization projects across the PowerSchool community.
How does it work: basically, it creates a form and submits said form, via AJAX calls. It was inspired by the “helper” file method.
Thanks to the PowerSchool development community whose contributions have been a big part of this project. This project has been transferred to ACME.
Download here: Community Exchange