Ad-hoc database queries

Reports ::: report_customsql
Maintained by TimTim Hunt, at the OU (Perry building)Mahmoud Kassaei, Hieu Vu Van
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.8 for Moodle 3.5+

Moodle 3.5, 3.6, 3.7, 3.8
Released: Tuesday, 12 November 2019, 12:44 AM

Code prechecks

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

Changes in 3.8

  • Report results can now be downloaded in any of data format that Moodle supports, not just CSV.
  • Admins can control the maximum possible limit for the number of rows a query can return.
  • Admins can now set which day is considered the first of the week for weekly reports. This defaults to the Moodle setting for this for new installs. For existing installs, it stays the same as before (Saturday) but you can change it.

Version information

Version build number
2019111101
Version release name
3.8 for Moodle 3.5+
Maturity
Stable version
MD5 Sum
9b2506ba3d723ba443424cf6ca7aacfc
Supported software
Moodle 3.5, Moodle 3.6, Moodle 3.7, Moodle 3.8
Change log URL
Alternative download URL

Version control information

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

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