Configurable Reports

Blocks ::: block_configurable_reports
Maintained by Juan Leyva, Sara Arjona Téllez
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.
Latest release:
14141 sites
4k downloads
435 fans
Current versions available: 5

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.

Screenshots

Screenshot #0

Contributors

Juan Leyva (Lead maintainer)
Sara Arjona Téllez: Developer
Please login to view contributors details and/or to contact them

Comments RSS

Comments

  • Sketch...
    Thu, 24 Oct 2019, 9:22 PM
    Simon, you should rather search and post in the forum: https://moodle.org/mod/forum/view.php?id=7979

    See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
  • Sketch...
    Thu, 24 Oct 2019, 11:01 PM
    Simon, you should rather search and post in the forum: https://moodle.org/mod/forum/view.php?id=7979

    See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
  • Jonny Galvez
    Wed, 13 Nov 2019, 7:29 PM
    We are having an issue with the user module outline stats where the report is returning that a user has been started but not yet completed, despite the user having completed the element. This seems to be happening inconsistently.

    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.
  • Brandon Jimenez
    Wed, 13 Nov 2019, 11:38 PM
    @Jonny Galvez: A couple of questions, are you having an issue just with a single user in a single activity in a single course, or is it more an issue with the activity and the completion settings. And, have you tried running the query directly on Maria/MySql?
  • Madhu Avasarala
    Thu, 21 Nov 2019, 4:13 AM
    There is a problem with Moodle Site Admin menu on Moodle 3.8 with this plugin verion 3.7.0 (corresponding to MOODLE_36_STABLE branch on GitHub). Presumably, improper javascript isues caused by this plugin is preventing javascript of Moodle Core to be properly executed. Please see bug tracker: https://tracker.moodle.org/browse/CONTRIB-7909
  • Jonny Galvez
    Tue, 26 Nov 2019, 10:59 PM
    @Brandon Jimenez: we worked out that in fact the users that were being reported as started but not yet completed on activity 1, yet had completed activity 2 were due to restarting activity 1 to refresh their knowledge. The plugin in fact reads their last attempt, despite having already completed and this completion showing in the completion progress block and in the tickbox.

    This may be a useful aspect of the plugin that could be updated going forward to avoid confusion for anyone else.
  • Sara Arjona Téllez
    Fri, 20 Dec 2019, 6:40 PM
    A new version of the plugin (3.8.0) has been released today and it should work with the most recent Moodle versions. Besides, a separate version (3.3.0) has been also released for 3.3 downwards, in order to fix https://github.com/jleyva/moodle-block_configurablereports/issues/125.

    Of course, there are still some remaining issues, but you can search and report and even work on them in the tracker (https://tracker.moodle.org/browse/CONTRIB-7882?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A%20Configurable%20report%22%20and%20resolution%20%3D%20Unresolved%20) or in the GitHub issues, as you prefer (https://github.com/jleyva/moodle-block_configurablereports/issues). Any help will be appreciated and patches are always welcomen wink

    If you have any question, you can send it to the community forum: http://moodle.org/mod/forum/view.php?id=7979 (in order to make it easier, please, avoid to send them duplicated to several places).
    And remember, if you're experiencing any issue, I would suggest to check if it has been reported previously in the tracker and, if not, create it smile

    Thanks in advance for your compresion and help! smile
  • Lyrics IN Backlinks
    Tue, 24 Dec 2019, 9:54 PM
    Nice one
  • Martin Biermann
    Mon, 30 Dec 2019, 10:05 PM
    The "Configurable reports" plugin is absolutely superbe. Sometimes a simple line of SQL can do wonders. I am currently running an e-course over 30 weeks. Each course week contains 3 - 4 quizes that need to be passed with at least 80 %. Then the week is passed in a binary fashion - either passed or not passed. Students have to pass all 30 days. I had trouble implementing this simple algorithm in standard Moodle. However, a relatively simple custom SQL query with the "Configurable Reports" plugin did the trick for me. To me, this was the ultimate proof of the supreme power of an open source learning management system.
  • Rick Jerz
    Mon, 30 Dec 2019, 10:45 PM
    I too use and love Configurable Reports. I would probably say that the design of Moodle, which uses a great database and has a great database table structure, and that one who knows SQL can do almost anything they want to do, is what your comment suggests to me. Configurable Reports provides a very nice front end to the Moodle database, with many great features. SQL was developed by Codd back in the late 1960's. His concept was, and still is, great.
  • Rick Jerz
    Mon, 30 Dec 2019, 10:47 PM
    I too use and love Configurable Reports. I would probably say that the design of Moodle, which uses a great database and has a great database table structure, and that one who knows SQL can do almost anything they want to do, is what your comment suggests to me. Configurable Reports provides a very nice front end to the Moodle database, with many great features. SQL was developed by Codd back in the late 1960's. His concept was, and still is, great.
  • Troy May
    Tue, 14 Jan 2020, 5:05 AM
    What doe it mean when you are configuring a report and it leads to a white blank page?
  • Miguel González Laredo
    Tue, 14 Jan 2020, 5:04 PM
    Hi, @Troy May. According to my experience, that error could be because of a wrong query result. This amazing plugin sometimes does not work properly if there is any problem with the dataset obtained from SQL.

    Have you tested your query out of Moodle (e.g. MySQL browser) and/or with different datasets?
  • Troy May
    Tue, 14 Jan 2020, 10:27 PM
    Thanks for your reply Miguel! It happens when I attempt to configure a report. For example, I choose to create a new Users Report. I choose 10 for Pagination, the Javascript ordering tick, the run from remote db, as well as export to csv. On the next page, I choose User statistics, then "logins in the platform". I name the column Col001, then hit Add. White screen of death anyone else? Another scenario is I choose to NOT run from remote db then on the next page choose only User course completion status. The screen immediately jumps to white blank before I can even hit Update. Please help.
  • Troy May
    Tue, 14 Jan 2020, 10:31 PM
    It would be REALLY great if someone just made a video of this plugin being installed-doing its thing-etc. Just please don't film it eating ice cream or running from the police. Thanks.
Please login to post comments