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 the HTML ASCII code for it instead.

Worked a charm.

For sqlReports4, you should use these ASCII codes without quotation marks around them.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.