It appears that runQuery doesn’t work in a Calculated Roster script. If I comment out the line, the script runs and I get a roster. When remove the comment and cause an alarm to occur, it looks like it fails and then the script cannot return a roster.
The script is:
The error I get in the logger is:
In the script console, it runs fine and returns a dataset:
What is going on? I want to be able to create an SQL string and run a query to build a roster. Can I not do this?