-
Escaping an apostrophe on a PowerSchool custom page variable
-
Using GET input to search in a PowerSchool custom page
-
PowerSchool tlist_sql fails but SQL Developer query is fine
-
Converting seconds to time in PowerSchool custom pages
-
PowerSchool Custom Pages Exporting Tables to .csv Using jQuery
-
PowerSchool custom pages and REGEXP_LIKE
In general, if you test a SQL query in SQL Developer against your PowerSchool database, that same SQL query should work in a PowerSchool custom page using ~[tlist_sql][/tlist_sql]. It does not, however—I discovered just now—work if you include a REGEXP_LIKE as part of your query. Will work fine in SQL Developer… just not in a…
-
PowerSchool custom pages tlist sql queries for specific courses
-
Using “current selection” of students in PowerSchool custom pages
-
Getting GPA methods into a PowerSchool custom page that uses tlist_sql
Acknowledgements: the actual genius of this workaround approach (including the important snippets of code) is from Adam L. on the PowerSource forums (you can search the forums for a thread entitled “tlist_sql and GPA methods”).I find ~[tlist_sql] handy for doing reports out of PowerSchool, because it’s transparent (someone can look directly at the page code…
-
Using text variables in tlist_sql queries in PowerSchool
On custom pages in PowerSchool, you have the option to use something called tlist_sql to run SQL queries on your PowerSchool database. Sometimes, you can insert variables in your query. I’ve had good luck with SQL queries using built-in variables that are essentially a number: ~[tlist_sql; SELECT t.Name, to_char(st.Test_Date, ‘MM/DD/YYYY’), st.Grade_Level, ts.Name, ts.Description, sts.NumScore, sts.studenttestid…