Thanks for all the help so far. I had a question about a plugin I am uploading via the plugin management dashboard to grab data from the Incidents tables.
I'm getting an error (filenames changed for privacy):
"myquery.xml: PowerQuery com.myquery.dataset cannot determine table name of column incidentid
Update: I successfully got the plugin to load! I reformatted by query and although the results table and logic is exactly the same, Powerschool seems to be happier. However, that has created some new problems:
"org.hibernate.exception.SQLGrammarException: could not extract ResultSet"Some Googling shows this could be connected to some column names not matching, but I've triple checked and can't find any issues.
Perhaps these two are related? My query is still somehow mis-formatted, and thus I can not use it as an export template?
Thanks in advance!
Good Day! I recommend working with the PowerSchool SIS administrators in your school district who assisted you with developing this sql as they will be in a better position to guide you further. Meanwhile, you can review our developer's guide and look for similar solutions on PowerSchool Exchange.
Note: You will need to work with the technical contacts in your district to review the information on PowerSource Exchange.
Kudos encourage participation