Reports: Ad-hoc database queries

report_customsql
Maintained by Tim at Lone Pine Koala Sanctuary Tim Hunt, at the OU (Perry building) Mahmoud Kassaei
This report plugin allows Administrators to set up arbitrary database queries to act as ad-hoc reports. Reports can be of two types, either run on demand, or scheduled to run automatically. Other users with the right capability can go in and see a list of queries that they have access to. Results can be viewed on-screen or downloaded as CSV.

Ad-hoc database queries 2.2.1 for Moodle 2.2

Picture of Gavin Henrick
Gavin Henrick
Friday, 20 January 2012, 1:16 AM
Usability
10/10
General comments
This admin report provides a way to create completely custom reports by enabling the user to enter in SQL queries which the report engine then runs. Background This module was released for Moodle 1.9 back in October 2009.  It was written by Tim Hunt of the Open University. It was later upgraded for Moodle 2 by Derek Woolhead also of the Open University.  For those unfamiliar with Tim’s work, he is the maintainer of the Quiz activity module in Moodle. It has recently had another nice feature ad...
Usability
Is it simple to install? Yes. After downloadined eeded to  extracted the folder and rename to customsql. I uploaded this into the moodle\report  folder of my Moodle site. When it was installed through the notifications page, the plug-in caused no errors and brought up no extra global settings. Is there documentation for it? The plug-ins page has a brief overview on the module. The Moodle Docs page is very detailed with a good number of example reports. There is also a list of 45 other report...