Ad-hoc database queries

Maintained by Tim Hunt, Mahmoud Kassaei, Hieu Vu Van
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.
Free
Download for free
Supports Moodle 1.9-5.1 See all versions
Latest release: 2 weeks ago
Installations: 4762
Downloads (last 90 days): 609
Frankenstyle name: report_customsql
Reports

Comments are no longer open for new posts. Existing comments remain available to read.

Jorge Cruz
I'm here to endorse the great usefulness of this plugin for good Moodle administration. And... kkkkk... i have to ask: when will the version for Moodle 5.0 be released???? On that day the Moodle community will be celebrating!!!!!!
Pascal Pitteloud
Hello,
This is a great plugin that I use weekly.
We are planning to update our Moodle to version 5.
I've seen a lot of commit on your github page.
Are you planning to update this moodle page too to reflect the changes ?
Thanks for your support
genivan santos
When will there be an update to Moodle 5.x?
A white man with a reddish beard and short hair in a white shirt with sunlight shining on his face.
There are updated versions of this plugin available at its GitHub source control URL, including for Moodle 4.5. Go to the github to see the git installation instructions.
JC
I have installed the plugin in a moodle 4.5 with php 8.3 and it went smooth.
Just a super minor cosmetic issue in the category list of queries.
Michael Milette
Hi Tim, when do you think we might be able to see a release compatible with Moodle 4.5 (LTS)?
Giovanni Mancini
Hi
I updated the plugin to the latest version and I have this error, already displayed in the past
PHP deprecated: the strftime() function is deprecated in /var/www/vhosts/sedex.formazionelavoratori.online/httpdocs/report/customsql/locallib.php at line 611
Versionephp 8.1.30
Moodle 4.5+
Motasem Al Haj Ali
This plugin has been very useful for us at DCU, and it would be great if we could continue using it.
Michael Milette
Good day, I was wondering, when do you think we can expect to see a release of this useful plugin for Moodle 4.5 LTS?
Robert Wagenhoffer
Hello,
Just upgraded to Moodle 4.5 and noticed a cosmetic error with this plugin. Looks like Moodle use to use small little diamond arrows next to each category that could be expanded. With this upgrade, these diamonds are now black arrows. However, on this plugin the arrows are way to large and it looks terrible. If anyone is still maintaining this app, please take a look at this when you have time. thank you.
Fabian Glagovsky
Hi Tim, is there anything we can do to have this plugin certified for Moodle 4.3+ here?
Best,
Avon Blyth
I am having an issue with a report designed to be run by end users.
The reports get data based on the current user %%USERID%%. Most of the time the reports work fine, however if two users run the same report at the same time, it displays both users data to one of the users.
I have tested this by creating a basic SQL query then have two users access it at the same time.
This is the query used for testing:
SELECT u.firstname
FROM {user} u
WHERE u.id = %%USERID%%
This results in one of the users getting two names, and the other just getting their name.
Is there any thing I can do to prevent this, anything I am doing wrong, or is this a bug?
David Lowe
If I want to create a report that looks at students in a course doing stuff in the first week while also having a subquery that's looking in the standard_log table (timecreated) I end up with multiple date inputs when I only need 1.
Is there anyway to use the same variable multiple times with one input?
Thanks.
Fabian Glagovsky
Thank you Tim!
Tim
The latest code in github works with 4.3. (I am working to publish the latest code here too, but there are only so many hours in each day.)