Ad-hoc database queries

Reports ::: report_customsql
Maintained by TimTim Hunt, at the OU (Perry building)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.
Marcus Green
onsdag, 26. august 2015, 03:17
General comments
This is a mature program that has been around since before Moodle 2.0 and has been downloaded tens of thousands of times. It was created by the UK Open University, who run one of the worlds largest Moodle installations. Because it is supported by the OU it is very likely to be kept up to date with future releases of Moodle. To create new reports you will need to be familiar with the industry standard SQL (Structured Query Language), and for full advantage you will need to understand table joins....