Reports: Ad-hoc database queries
Maintained by Tim Hunt, 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.9 for Moodle 2.7+ for Moodle 2.7, 2.8, 2.9
Ad-hoc database queries 2.2.1 for Moodle 2.2
Friday, 20 January 2012, 1:16 AM
- 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...
- 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...