That script does not work on my Moodle.
I understand if you look at the notes on an ad hoc edit page, you can see:
- You can put parameters into the SQL using named placeholders, for example :parameter_name. Then, when the report is run, the user can enter values for the parameters to use when running the query.
- If the :parameter_name starts or ends with the characters date then a date-time selector will be used to input that value, otherwise a plain text-box will be used.
- You cannot use the characters : or ? in strings in your query. If you need them, you can use CHR(58) and CHR(63) respectively, along with string concatenation. (It is CHR for Postgres or Oracle, CHAR for MySQL or SQL server.)
However, I have no idea how this is usable, nor how your script works on your LMS.