Moodle plugins directory: Ad-hoc database queries: Reviews | Moodle.org
Ad-hoc database queries
Reports ::: report_customsql
Maintained by 
Tim Hunt, 
Mahmoud Kassaei, 
Anupama Sarjoshi
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.9 for Moodle 2.7+ for Moodle 2.7, 2.8, 2.9
Ad-hoc database queries 2.2.1 for Moodle 2.2
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...