Reports: Ad-hoc database queries

report_customsql
Maintained by Tim at Lone Pine Koala Sanctuary Tim Hunt, at the OU (Perry building) Mahmoud Kassaei
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.3 for Moodle 2.2+

Release notes

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.

Scheduled reports can also be set to be send out be email whenever they are
generated.

See http://docs.moodle.org/24/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/). There have also been contibutions
but many others.

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. (Tested on
Moodle 2.3+.)
Moodle 2.2, 2.3, 2.4

Version information

Version build number
2013031200
Version release name
2.3 for Moodle 2.2+
Can be updated from
2.2.0 (2011121300), 2.0.0 (2011050500), 1.9.0 (2009103000), 2.0.1 (2011050500), 2.2.1 (2012011900)
Can be updated to
2.5 for Moodle 2.4+, 2.6 for Moodle 2.4+ (2014020700), 2.7 for Moodle 2.4+ (2014061800)
Maturity
Stable version
MD5 Sum
7360b8f3cdef9dbd53c1fe59bcfcb6e5
Supported software
Moodle 2.2, Moodle 2.3, Moodle 2.4

Version control information

Version control system (VCS)
GIT
VCS repository URL
VCS branch
master
VCS tag
v2.3

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