Moodle plugins directory: Ad-hoc database queries: Versions: 3.6 for Moodle 3.3+ | 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 3.6 for Moodle 3.3+
Moodle 3.3, 3.4, 3.5, 3.6
Released: Freitag, 23. November 2018, 02:58
Changes in 3.6
- New feature for columns that are links. If the SQL query returns two
columns
name
andname_link_url
(for any value ofname
) then the that will be shown as a single column of links, where the visible link text comes from thename
column, and the URL comes from thename_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
- Latest release for Moodle 3.3
- Latest release for Moodle 3.4
- The more recent release 3.9 for Moodle 3.5+ (2020062800) exists for Moodle 3.5
- The more recent release 3.9 for Moodle 3.5+ (2020062800) exists for Moodle 3.6
Version control information
- Version control system (VCS)
- GIT
- VCS repository URL
- VCS tag
- v3.6
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