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
Screenshots
Can anyone help me with that? This plugin can be customized to do what I need?
I need an academic plugin for Moodle 3.7 that will take in calculations
the promotions (that are formed from 3 universitary years, i.e.: univ.
years 2019-2020, 2020-2021, 2021-2022 will make part from promotion
2019-2022), the universitary years like in above example, courses from
universitary years by semesters(sem.1, sem.2) and users that access/have
activities (or not) on that courses.
Reports that I need to display and save in csv, MS Excel or pdf are:
-Numbers of courses per semester in a selected universitary year(i.e.:
2019-2020) from a selected promotion (i.e.: 2019-2022), how much users
participate/had activities on each course, role (student, teacher, etc.),
and of course in a timeline (from beginning of logs until present day).
The plugin would be great if will work with already acumulated logs.
Can anyone help me with that? This plugin can be customized to do what I
need?
Of course I need that graphics displayed to be in form of bars & pie for
an unadvised audience.
@ Mr. Miguel González Laredo
I installed Moodle in october 2018 and from then we had various activities and in its logs/journals are recorded that informations until in present day, now from the beginning I opted to save logs in files on hardisk, NOT IN DATABASE.
I hope to fully clarify you this answer.
The main purpose of this plugin is to make SQL queries that could potentially be exported as reports. Since you have those logs stored in external files, that can't be done directly. that being said, maybe you could create a new logs table in the DB and then create a SQL report. If done properly, i think it could give you the desired results. Other than that, custom plug-in is your answer.
I would have a query for this filter %% FILTER_COURSEMODULEFIELDS%. Does anyone know its exact syntax in SQL? I try to integrate it into the SQL query, but after entering the filter nothing happens at all. Specifically, I would need to filter out all users by institution. I use the Configurable Reports module.
Thank you for your help.
Not sure if this is the correct place to message this but I'm really enjoying the flexibility of this tool but I believe there is a bug in the latest version whereby choosing custom template simply generates the following in the report view:
ArrayArrayArrayArrayArrayArrayArray
Is this correct?
See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
Do you have any suggestions on how we can fix this? We find this plugin extremely valuable when it's returning the correct completion status.
This may be a useful aspect of the plugin that could be updated going forward to avoid confusion for anyone else.