Moodle plugins directory: Ad-hoc database queries: Versions: 2.4 for Moodle 2.2+ | Moodle.org
Ad-hoc database queries
Ad-hoc database queries 2.4 for Moodle 2.2+
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.
If a column has a name ending in 'date' and contains integer values, then they will be assumed to be unix timestamps, and formatted as dates. If a query placeholder has a name ending in 'date', then users will be give a date-time selector to input the value of that parameter.
You can set a limit on the maximum number of rows returned by a query (up to the hard limit of 5000).
See http://docs.moodle.org/25/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, as you can see in the git log.
To install using git, type this command in the root of your Moodle install git clone
git@github.com:moodleou/moodle-report_customsql.git report/customsql
This version of the report is compatible with Moodle 2.2 or later. (Tested on Moodle 2.4+.)
Version information
- Version build number
- 2013062400
- Version release name
- 2.4 for Moodle 2.2+
- 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
- fe6db32934f8c9af367b64c9635fd1f1
- Supported software
- Moodle 2.2, Moodle 2.3, Moodle 2.4, Moodle 2.5
- Latest release for Moodle 2.2
- Latest release for Moodle 2.3
- The more recent release 2.7 for Moodle 2.4+ (2014061800) exists for Moodle 2.4
- The more recent release 2.7 for Moodle 2.4+ (2014061800) exists for Moodle 2.5
Version control information
- Version control system (VCS)
- GIT
- VCS repository URL
- VCS branch
- master
- VCS tag
- v2.4
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