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

Moodle 3.9, 3.10, 3.11, 4.0
Released: lørdag den 19. marts 2022, 00:21
Download

Code prechecks

phplint phpcs0 | 37 js css phpdoc74 | 0 savepoint thirdparty externalbackup0 | 2 grunt2 | 0 shifter mustache gherkin
HTML | XML

Changes in 4.2

  • This version works with Moodle 4.0.
  • There is now an option to fetch query results via webservice/pluginfile.php, once the permissions are set up right.
  • Better navigation when there are a lot of reports. There is now a separate page for each category, as well as the main index page.
  • When editing queries, the input box for the report name is bigger.
  • Actions (e.g. edit) for reports are now shown on the parameters page, and are shown before the list of preview report runs, under scheduled reports, which is more convenient.
  • Fixed a bug with the display of validation messages on the edit form.
  • Added a missing index in the database.

Version information

Version build number
2022031800
Version release name
4.2 for Moodle 3.9+
Maturity
Stabil version
MD5 Sum
949b4736aa40605b4b9cb8a9b23ba283
Supported software
Moodle 3.9, Moodle 3.10, Moodle 3.11, Moodle 4.0
  • Latest release for Moodle 3.9
  • Latest release for Moodle 3.10
  • Latest release for Moodle 3.11
  • Latest release for Moodle 4.0
Change log URL
Alternative download URL

Version control information

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

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