Skip to content

A Moodle report plugin that lets you easily create simple reports that can be expressed as a single SQL query

Notifications You must be signed in to change notification settings

wcel/moodle-report_customsql

 
 

Repository files navigation

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.

About

A Moodle report plugin that lets you easily create simple reports that can be expressed as a single SQL query

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • PHP 100.0%