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 4.1 for Moodle 3.9+

Moodle 3.9, 3.10, 3.11
Released: Wednesday, 7 July 2021, 6:58 PM

Code prechecks

phplint phpcs0 | 14 js0 | 1 css0 | 1 phpdoc62 | 0 savepoint thirdparty grunt shifter mustache gherkin
HTML | XML

Change log for the Ad-hoc database queries report

Changes in 4.1

  • We now track when each query was created and last modified, along with the user who modified it. (With the necessary Privacy API bits.)
  • Fix the sort-order of reports on the index page.
  • Fix the bug with list of email recipients being saved wrongly.
  • Fix a bug when the value in a cell ended in a backslash.
  • Minor styling fix.
  • Updates to make everything work with Moodle 3.11.

Version information

Version build number
2021070700
Version release name
4.1 for Moodle 3.9+
Maturity
Stable version
MD5 Sum
fe8f6467f7b0bf6708cd65a22c2f8408
Supported software
Moodle 3.9, Moodle 3.10, Moodle 3.11
Change log URL
Alternative download URL

Version control information

Version control system (VCS)
GIT
VCS repository URL
VCS tag
v4.1

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