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.

Ad-hoc database queries 3.9 for Moodle 3.5+

Moodle 3.5, 3.6, 3.7, 3.8, 3.9
Released: Monday, 29 June 2020, 1:49 AM
Download

Code prechecks

phplint phpcs js0 | 1 css phpdoc60 | 0 savepoint thirdparty grunt shifter mustache gherkin
HTML | XML

Changes in 3.9

  • Scheduled reports which accumulate one row at a time now display with the most recent data at the top.
  • When sending emails for scheduled reports, the number of rows in the results is now added to the subject line.

Version information

Version build number
2020062800
Version release name
3.9 for Moodle 3.5+
Maturity
Stable version
MD5 Sum
b9f4db23daa8a9952d52aba021bec772
Supported software
Moodle 3.5, Moodle 3.6, Moodle 3.7, Moodle 3.8, Moodle 3.9
  • Latest release for Moodle 3.5
  • Latest release for Moodle 3.6
  • Latest release for Moodle 3.7
  • Latest release for Moodle 3.8
  • The more recent release 4.2 for Moodle 3.9+ (2022031800) exists for Moodle 3.9
Change log URL
Alternative download URL

Version control information

Version control system (VCS)
GIT
VCS repository URL
VCS tag
v3.9

Default installation instructions for plugins of the type Reports

  1. Make sure you have all the required versions.
  2. Download and unpack the module.
  3. Place the folder (eg "myreport") in the "report" subdirectory.
  4. Visit http://yoursite.com/admin to finish the installation