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.5 for Moodle 3.4+

Moodle 3.4, 3.5
Released: Thursday, 9 August 2018, 11:20 PM

Changes in 3.5

  • Privacy API implementation.
  • Fix escaping of values in reports that contain HTML special characters.
  • Fix bug where the report name was missing from scheduled task emails.
  • Fix some coding style issues.
  • Due to privacy API support, this version now only works in Moodle 3.4+ For older Moodles, you will need to use a previous version of this plugin.

Version information

Version build number
2018080900
Version release name
3.5 for Moodle 3.4+
Maturity
Stable version
MD5 Sum
5ffb7eb9ea308ea55c68a7feca277ddc
Supported software
Moodle 3.4, Moodle 3.5

Version control information

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

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