Tag: tlist_sql
-
Viewing test scores in a PowerSchool custom page
By default, PowerSchool will show you a list of tests, and then you have to drill down into each test to get to the actual set of scores. There isn’t a way built into PowerSchool to view all the scores and subscores for a particular student. Previously, I’d created a custom page that fetched a…
-
PowerSchool tlist_sql fails but SQL Developer query is fine
Full props to Romy from the PowerSource forums for helping me sleuth a problem with a query working just fine in SQL Developer but then failing (with a blank-loaded page) in tlist_sql on a PowerSchool custom page. Basically, a colon, even within quotation marks, messes up the query within tlist_sql, so I had to use…
-
PowerSchool custom pages tlist sql queries for specific courses
Usually if you’re doing a tlist_sql query on a PowerSchool custom page, any SQL query that actually works in SQL Developer will work on the custom page. I found an odd one today, though—if you have a SQL query that actually works in SQL Developer that uses course names (e.g., ((course_name=’Name of One Course’) OR…
-
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…
-
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…
-
Creating a custom page in PowerSchool for a .csv export
Even though teachers can easily get their own class lists out as an export from Gradebook, and you can also use DDE (Direct Database Export) to get such a list out after having selected the group of students, I thought it’d be nice to have a page that’s dedicated to get a .csv out of…
-
Making PowerSchool custom pages useful for sophisticated reporting
If you don’t want to use PDO on a WAMP server to connect to and report from your PowerSchool database, you may still want to do some sophisticated reporting from PowerSchool’s custom pages. Unfortunately, custom pages is a bit of a coarse tool that’s also not well documented (in terms of sophisticated reporting—simple reporting has…