Moodle plugins directory: Ad-hoc database queries: Versions: 2.2.1 | 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 2.2.1
Moodle 2.2
Released: Friday, 20 January 2012, 12:39 AM
Ad-hoc database queries
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.
Reports can contain placeholders, in which case, the user running the report is
presented with a form where they can enter the values to substitute for the
placeholders before running the report.
See http://docs.moodle.org/22/en/Custom_SQL_queries_report for more information.
Written by Tim Hunt and converted to Moodle 2.0 by Derek Woolhead, both from
The Open University (http://www.open.ac.uk/).
To install using git, type this command in the root of your Moodle install
git clone git://github.com/timhunt/moodle-report_customsql.git report/customsql
This version of the report is compatible with Moodle 2.2 or later.
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.
Reports can contain placeholders, in which case, the user running the report is
presented with a form where they can enter the values to substitute for the
placeholders before running the report.
See http://docs.moodle.org/22/en/Custom_SQL_queries_report for more information.
Written by Tim Hunt and converted to Moodle 2.0 by Derek Woolhead, both from
The Open University (http://www.open.ac.uk/).
To install using git, type this command in the root of your Moodle install
git clone git://github.com/timhunt/moodle-report_customsql.git report/customsql
This version of the report is compatible with Moodle 2.2 or later.
Version information
- Version build number
- 2012011900
- Version release name
- 2.2.1
- Can be updated from
- 2.2.0 (2011121300), 2.0.0 (2011050500), 2.0.1 (2011050500)
- Can be updated to
- 2.3 for Moodle 2.2+ (2013031200), 2.5 for Moodle 2.4+, 2.6 for Moodle 2.4+ (2014020700), 2.7 for Moodle 2.4+ (2014061800), 2.8 for Moodle 2.7+ (2014111200)
- Maturity
- Stable version
- MD5 Sum
- c29f3e69579bddb0c813075a0b7f33cf
- Supported software
- Moodle 2.2
- The more recent release 2.4 for Moodle 2.2+ (2013062400) exists for Moodle 2.2
Version control information
- Version control system (VCS)
- GIT
- VCS repository URL
- VCS branch
- master
- VCS tag
- v2.2.1
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