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.6 for Moodle 3.3+

Moodle 3.3, 3.4, 3.5, 3.6
Released: Friday, 23 November 2018, 2:58 AM
Download

Code prechecks

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

Changes in 3.6

  • New feature for columns that are links. If the SQL query returns two columns name and name_link_url (for any value of name) then the that will be shown as a single column of links, where the visible link text comes from the name column, and the URL comes from the name_link_url column.
  • The exact case of the column titles is extracted from the query. So, if your query is SELECT 'x' AS My_HTML, previously the table would display the column heading as 'my html'. Now it will show 'My HTML'.
  • A summary of the number of rows output under the table.
  • Moodle 3.3 compatibility re-established thanks to Paul Holden.
  • Behat tests fixed for Moodle 3.6.

Version information

Version build number
2018112200
Version release name
3.6 for Moodle 3.3+
Maturity
Stable version
MD5 Sum
b4bced22d4acf1e5dd9da63a75a52bf2
Supported software
Moodle 3.3, Moodle 3.4, Moodle 3.5, Moodle 3.6
Change log URL
Alternative download URL

Version control information

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

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