Blocks: 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
Useful links
Screenshots
I am getting this error. Is it because my Moodle version is not supported?
Validating block_configurable_reports ... Error
[Error] Write access check [/opt/bitnami/apps/moodle/htdocs/blocks]
Installation aborted due to validation failure
i keep have a strange error while using your plug (Moodle 2.9.9...):
I'm trying to create a template using the documentation you have provided for your plug, but my editor (atto) keeps adding some additional tags so i can't complete the new template as i would like to. I realise this is not 100% your plugin's fault, but, in short, is there any workaround from the settings of your plug to allow using the template as defined in the tutorial?
Regards
Also, is it possible when using the search text filter to have no results initially before applying a filter? Thanks for any feedback! -Ben
Thanks!
/blocks/configurable_reports/viewreport.php?id=33&courseid=1&filter_var=360
you can then have a "where" statement that uses it eg
where u.id="%%FILTER_VAR%%" /* dangerous code don't do this!! */
The problem is that this opens up big vulnerabilities for code injection allowing people to access anything in the database. What we did is use the filter variable in the sql in a way that prevents code being injected by limiting what will be read to a number of less than 6 digits eg
where u.id=(if(length("%%FILTER_VAR%%") >=1, if(length("%%FILTER_VAR%%") <6,cast("%%FILTER_VAR%%" As Decimal),1), 1)))
We think this is hack proof, if you can see issues with it then do let me know.
Ken
u.id=(if(length(%%FILTER_VAR%%) >=1, if(length(%%FILTER_VAR%%) <6,cast(%%FILTER_VAR%% As Decimal),1), 1))
Thanks again! Cheers. -Ben
Is it possible to get the sql query of Course Completion? I want to create a report that shows a summary of the training program (username and completion status of each course). The report has a "Details" Button that should show additional course information (task completed etc).
Any idea if this can be achieved through custom reports?
Make sure you use the parameterised queries which are built into Moodle, and the correct variable type with optional_param()/required param() for your URL arguments and then you'll be safe.
Many thanks in advance,
Przemek