I have just put out a new version of this plugin.
Notable new features include:
- Better handling of dates. If a column has a name ending in 'date' and contains integer values, then they
will be assumed to be unix timestamps, and formatted as dates. If a query
placeholder has a name ending in 'date', then users will be give a date-time
selector to input the value of that parameter. Thanks to Mahmoud Kassaei of the Open University, UK. Laura McLeod (OU) also deserves thanks for incredibly patient testing, and finding lots of things that Mahmoud and I missed during development. - Ability to change the limit on the number of rows returned. We still won't let you increase beyond hard limit of REPORT_CUSTOMSQL_MAX_RECORDS = 5000 (unless you edit the code) but you can now make a query to return the top 10 of something. Thanks to Troy Williams or The University of Waikato, NZ.
- If the report you are trying to create returns an error, then the full database error is displayed on the editing form. Thanks to Tim Hunt, the Open University, UK.
This should work with all versions of Moodle 2.2 -> 2.5. As ever, let us know if you encounter any problems.