Moodle Plugins directory: Configurable Reports | Moodle.org
Configurable Reports
This block is a Moodle custom reports builder.
You can create custom reports without SQL knowledge. It's a tool suitable for admins or teachers.
What type of reports can I create?
- Courses reports, with information regarding courses.
- Categories reports, with information regarding categories. A courses report can be embedded in this type of report.
- Users reports, with information regarding users and their activity in a course.
- Timeline reports, this is a special type of report that displays a timeline. A course or user report can be embedded in this timeline showing data depending on the start and end time of the current row.
- Custom SQL Reports, custom SQL queries. This block can use the same SQL queries that Tim Hunt's Custom SQL queries plugin.
Note for developers: You can create your own type of reports.
Who can view the reports?
When you create a report you can select which users can view it.
Links to reports are displayed in a block in the course or site frontpage.
Advanced features
Filters, pagination, logic conditions and permissions, plots, templates support, export to xls .
Request for new report types and plugins are welcome, please use the link "Bugs and issues" at the right.
Links
Screenshots
I hope some day it will solve two major issues in reports with large amount of data:
- for reports with filters, it should load results after clicking the Apply button and not before.
- default search field should also work with paging enabled. That means replacing Javascript search with Ajax or something.
One more suggestion for developers... regarding SQL reports, filtering syntax is really too limiting and complicated without real reason. Could you just use filter values as variables instead? That would make life so much easier for anyone that codes custom SQL queries for this report. This would also remove so much limitations of the current plugin and it would make plugin's PHP code so much cleaner, smaller and simple.
%%FILTER_SEARCHTEXT_lastname:uu.lastname:~%%
works, but case insensitive does not ?
%%FILTER_SEARCHTEXT_lastname:uu.lastname:~*%%
it is error or by design ?
We are using Moodle version 4.5.4+ (Build: 20250502) with plugin version 2024051300, and we’ve noticed that the plugin uses the deprecated function get_all_user_name_fields() in multiple places.
As of recent Moodle versions, it seems this function has been deprecated and removed from core. It should be replaced maybe with: \core_user\fields::get_name_fields().
Regards
In moodle 4.5 in RTL languages it's hard to move the mouse inside the SQL editing zone.
The cursor can be moved by using keyboard arrows but not the mouse itself.
I hope you are well, it's been ages. Block Reports appears to work on Moodle 5. Could you update the supported extension on your end to Moodle 5 so that it installs automatically each week when we update our Moodle instance? It saves us so much time. Cheers.
Here is the start of the SQL:
SELECT grc.description AS Rubric_Description,
asg2.name AS Assignment_Name
The search is NOT working on Assignment_Name, only on Rubric_Description in this example.
Thank you for your time.
SELECT grc.description AS Rubric_Description,
asg2.name AS Assignment_Name
FROM ...
WHERE ...
%%FILTER_SEARCHTEXT:CONCAT(grc.description,' ',asg2.name):~%%
Each of the columns that you want to be searchable must be included in the %%FILTER_SEARCHTEXT:...:~%% filter parameter.
You should use the Configurable Reports FORUM for questions like this. See https://moodle.org/mod/forum/view.php?id=7979