Moodle plugins directory: Ad-hoc database queries: Versions: 4.0 for Moodle 3.9+ | Moodle.org
Ad-hoc database queries
Reports ::: report_customsql
Maintained by Tim Hunt, 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.0 for Moodle 3.9+
Moodle 3.9, 3.10
Released: Saturday, 19 December 2020, 5:35 AM
Code prechecks
phplint
phpcs0 | 2
js0 | 1
css0 | 1
phpdoc61 | 0
savepoint
thirdparty
grunt
shifter
mustache
gherkin
HTML | XMLChanges in 4.0
- Fix downloading for Moodle 3.9+.
- When editing queries, the SQL field is now styled more prettily.
- For scheduled reports, the list of users to email is now stored as a list of userids, rather than usernames. (Configuration of existing reports is automatically updated on upgrade.)
Version information
- Version build number
- 2020121800
- Version release name
- 4.0 for Moodle 3.9+
- Maturity
- Stable version
- MD5 Sum
- b1b0fea94662db4eb9c56f2999e44246
- Supported software
- Moodle 3.9, Moodle 3.10
- The more recent release 4.2 for Moodle 3.9+ (2022031800) exists for Moodle 3.9
- The more recent release 4.2 for Moodle 3.9+ (2022031800) exists for Moodle 3.10
Version control information
- Version control system (VCS)
- GIT
- VCS repository URL
- VCS tag
- v4.0
Default installation instructions for plugins of the type Reports
- Make sure you have all the required versions.
- Download and unpack the module.
- Place the folder (eg "myreport") in the "report" subdirectory.
- Visit http://yoursite.com/admin to finish the installation