Ad-hoc database queries

Reports ::: report_customsql
Maintained by Tim at Lone Pine Koala SanctuaryTim 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.
Latest release:
3793 sites
146 fans
Current versions available: 10

This report, created by The Open University, lets Administrators set up arbitrary SQL select queries that anyone with the appropriate permissions can then run. Reports can be set to be runnable on-demand, or automatically run weekly or monthly.

The results are displayed as a fairly plain HTML table, and can also be downloaded as CSV.

The idea is that this lets you quicly set up ad-hoc reports, without having to create a whole new admin report plugin.


Screenshot #0


Tim at Lone Pine Koala Sanctuary
Tim Hunt (Lead maintainer)
at the OU (Perry building)
Mahmoud Kassaei: Developer
Please login to view contributors details and/or to contact them

Comments RSS


  • now with Less Beard(TM)
    Tue, Jan 3, 2012, 10:43 PM
    This is the "Custom SQL Queries Report" plugin. Unfortunately, it is named differently here from the docs page, so searching for it is difficult.
  • now with Less Beard(TM)
    Tue, Jan 3, 2012, 10:48 PM
    Also, it is not clear what version(s) of Moodle are supported/required by this plugin. Looks like Moodle 2.X and up, only.
  • Tim at Lone Pine Koala Sanctuary
    Wed, Feb 8, 2012, 12:38 AM
    I have now uploaded a version for Moodle 1.9 as well.
  • Wed, Sep 5, 2012, 10:51 PM
    I installed the "Ad-hoc database queries" plugin. It installed fine, but when I go to add a new query, enter the Query SQL and then click the "Save changes" button, I get the error message: "500 Internal Server Error, The server encountered an internal error or misconfiguration and was unable to complete your request."
    Can you help? Thanks.
Please login to post comments