Configurable Reports
Versions
Current version
5.2.0 (2027050401)
5.2.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2027050401
Version release name: 5.2.0
Maturity: Stable
Supported Moodle versions: 4.0, 4.1, 4.2, 4.3, 4.4, 4.5, 5.0, 5.1, 5.2
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 5.2.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
What's Changed
- #286 Fix security issue
- Fix search text with operator ~ case insensitive for PostgreSQL by @rmady in https://github.com/jleyva/moodle-block_configurablereports/pull/283
- Fix RTL cursor issue in editor by @kirildevlion in https://github.com/jleyva/moodle-block_configurablereports/pull/280
- Fix unit test failure test_db_install_file by @Fragonite in https://github.com/jleyva/moodle-block_configurablereports/pull/274
- Fix Undefined property: stdClass::$title notice by @luisdev in https://github.com/jleyva/moodle-block_configurablereports/pull/269
- #247 [CONTRIB-9748] The deprecated function get_all_user_name fields should be replaced if possible by @minhduchoang195 in https://github.com/jleyva/moodle-block_configurablereports/pull/265
- Fixes jleyva/moodle-block_configurablereports#172 by @marcelorhmaia in https://github.com/jleyva/moodle-block_configurablereports/pull/262
- Update evalwise.class.php by @alonsoarias in https://github.com/jleyva/moodle-block_configurablereports/pull/258
New Contributors
- @rmady made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/283
- @kirildevlion made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/280
- @Fragonite made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/274
- @luisdev made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/269
- @minhduchoang195 made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/265
- @alonsoarias made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/258
Full Changelog: https://github.com/jleyva/moodle-block_configurablereports/compare/4.5.0...5.2.0
4.5.0 (2024051300)
4.5.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2024051300
Version release name: 4.5.0
Maturity: Stable
Supported Moodle versions: 4.0, 4.1, 4.2, 4.3, 4.4, 4.5
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 4.5.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Configurable Reports Block
Installation, Documentation, Tutorials....
See http://docs.moodle.org/en/blocks/configurable_reports/
Also http://moodle.org/mod/data/view.php?d=13&rid=4283
Author: Juan Leyva
http://twitter.com/jleyvadelgado
Thanks to:
Sara Arjona for being a co-maintainer
Nadav Kavalerchik for developing amazing new features
Ivan Breziansky for translating the block to slovak language
Iñaki Arenaza for translating the block documentation to spanish
Luis de Vasconcelos for testing the block
Adam Olley and Netspot Moodle Partner for improving some parts of the Moodle2 version
Some functionalities of this plugin uses code from:
Admin Report: Custom SQL queries
http://moodle.org/mod/data/view.php?d=13&rid=2884
By Tim Hunt
VERSIONS HISTORY
4.5.0 (2024051300) for Moodle 4.5
Release date: 06.10.2024
What's Changed
- fix webservice calls when missing user by @danielneis in https://github.com/jleyva/moodle-block_configurablereports/pull/250
- Issue with downloading a filtered report by @luukverhoeven in https://github.com/jleyva/moodle-block_configurablereports/pull/248
- Apply format_string on the breadcrumb navigation by @golenkovm in https://github.com/jleyva/moodle-block_configurablereports/pull/181
- csv delimiter settings by @Tsheke in https://github.com/jleyva/moodle-block_configurablereports/pull/214
- Set current courseid when importing a custom SQL report. by @reskit in https://github.com/jleyva/moodle-block_configurablereports/pull/223
- Fixes jleyva/moodle-block_configurablereports#147 by @marcelorhmaia in https://github.com/jleyva/moodle-block_configurablereports/pull/231
- User Profile Fields Language Filter Fix by @sameer-ah in https://github.com/jleyva/moodle-block_configurablereports/pull/189
- Fix 201: Process report names / filenames through Moodle filters by @michael-milette in https://github.com/jleyva/moodle-block_configurablereports/pull/238
- FIX-226: Stop getting string from report_customsql plugin by @michael-milette in https://github.com/jleyva/moodle-block_configurablereports/pull/227
- Set BOM for CSV export closes #198 by @mvaraujo in https://github.com/jleyva/moodle-block_configurablereports/pull/199
- Provide support for SYLK export #200 by @mvaraujo in https://github.com/jleyva/moodle-block_configurablereports/pull/203
- Fix issue #62 Error with apostrophe by @TomoTsuyuki in https://github.com/jleyva/moodle-block_configurablereports/pull/211
- Export multilanguage support by @Tsheke in https://github.com/jleyva/moodle-block_configurablereports/pull/215
- Add embed options by @keevan in https://github.com/jleyva/moodle-block_configurablereports/pull/182
- fix variable redeclaration by @danielneis in https://github.com/jleyva/moodle-block_configurablereports/pull/256
New Contributors
- @luukverhoeven made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/248
- @golenkovm made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/181
- @Tsheke made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/214
- @reskit made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/223
- @marcelorhmaia made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/231
- @sameer-ah made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/189
- @TomoTsuyuki made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/211
- @keevan made their first contribution in https://github.com/jleyva/moodle-block_configurablereports/pull/182
4.1.0 (2023120600) for Moodle 4.1
Release date: 06.12.2023
This release focuses on solving issues in Moodle 4.1 and PHP 7.4 and start with small improvements and bug fixes.
- Reformat code
- Add CI testing based on Github Actions created by Catalyst IT
- Add PHP 7.4 support - minimum PHP version is now 7.4
- Add PHP 8.0 support
- Add PHP 8.1 support
- pChart library updated to version 2.4.0
- JS tablesorter library updated to version 2.31.3
- JS CodeMirror library updated to version 5.65.16
- Move repository to https://github.com/Lesterhuis-Training-en-Consultancy/moodle-block_configurablereports
- Original repository (https://github.com/jleyva/moodle-block_configurablereports) can be used for older release or use the old branches within this repository
- removed cr_add_to_log not used anymore
- Important this branch is not backwards compatible with Moodle 3.11 and lower
Thanks to Lesterhuis Training & Consultancy for the contribution / updated by Ldesign Media
- TODOS for the future:
- Namespaces for classes & autoloading
- Move all to
classestoclasses/directory - Clean up code
- Add tests
- AJAX_SCRIPT move to webservice
- unserialize() to json_decode()
- Readme to Markdown format
- validation if a class exists and inherits the correct parent class.
- Changelog to separate file
- Move cron to a scheduled task
- phpcpd and phpdocs checks in CI
- Make CSS strict should only affect this plugin!
3.9.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8, 3.9
Release date: Tuesday, 3 November 2020
- Starting this version for allowing SQL queries performing data insertion/creation the following configuration variable set to 1
is required in your site root /config.php:
$CFG->block_configurable_reports_enable_sql_execution = 1;
Otherwise, previous Custom SQL reports performing data insertion/creation will stop working. - Added matching colors to pie charts
- Added unmapped palette for general colors to pie charts
- Changed fuserfield to allow for multiple instances of the filter
- Added alphabetical sort to courses filter
- Added webservice to get reports data
- Added new filters for competencies
- Other fixes and improvements:
- Fix offset error for bar graphs when not using SQL reporting
- Removed default sorting from DataTables JS UI
- Fixed issue where colors would mismatch if values weren't present
- Fixed STARTTIME and ENDTIME variable substitution
- Avoid text filtering when exporting
Thanks Alex Rowe, David Saylor, Michael Gardener, Muhammad Osama Arshad, Daniel Poggenpohl, Daniel Neis, François Parlant and all the contributors who have sent several fixes and improvements.
3.8.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8
Release date: Friday, 20 Dec 2019
- Order the list of users in users filter by fullname considering language - #130
- Other fixes and improvements:
- Fix template array error - #132
- Fix DB mismatch between install.xml and upgrade.php - #123
- Fix LIMIT error for MSSQL - CONTRIB-7891
- Remove "_" from the table header titles - #137
- Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
Thanks Daniel Neis (danielneis), Mike McDougal (mcdoogs), Tuan Ngoc Nguyen (tuanngocnguyen), Mike Henry (mhenry79mnet), safatshahinsd, kristian-94 and all the contributors who have sent several fixes and improvements.
And special thanks also to Carlos, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.3.0 (2019121900) for Moodle 3.0, 3.1, 3.2, 3.3
Release date: Friday, 20 Dec 2019
- Order the list of users in users filter by fullname considering language - #130
- Add a new calculation type: percentage
- Allow userfields to be used more than once in the permissions
- Move JS to AMD modules
- Upgrade some 3rd party JS libraries
- Fix import from XML
- Review the year filter to take min and max years from the calendar factory
- Other fixes and improvements:
- Fix template array error - #132
- Fix DB mismatch between install.xml and upgrade.php - #123
- Fix LIMIT error for MSSQL - CONTRIB-7891
- Remove "_" from the table header titles - #137
- Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
- Fix error when using templates
- Fix error when using the Start/End filter
- Fix legacy_polyfill error when running unit tests
- Display custom title for the block
- Replace deprecated methods (htmleditor, pix_url and coursecat)
- Remove CSS files not found error in JS console
- Show breadcrumbs for users without manage report capability
- Fix DB query function call for the enrolled students filter
- Raise the memory limit when exporting
- Clean some request parameters before using them
- Fix error with user field search box filter
- Improve compatibility with PostgreSQL when importing
Thanks Daniel Neis (danielneis), Mike McDougal (mcdoogs), Tuan Ngoc Nguyen (tuanngocnguyen), Mike Henry (mhenry79mnet), safatshahinsd, kristian-94, David (davidpesce), Dimitrii (dmitriim), Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several fixes and improvements.
And special thanks also to Carlos, Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.7.0 (2019060300) for Moodle 3.4, 3.5, 3.6, 3.7
Release date: Monday, 3 Jun 2019
- Add a new calculation type: percentage
- Allow userfields to be used more than once in the permissions
- Other fixes and improvements:
- Fix error when using templates
- Fix error when using the Start/End filter
- Fix legacy_polyfill error when running unit tests
- Display custom title for the block
Thanks David (davidpesce), Dimitrii (dmitriim) and all the contributors who have sent several fixes and improvements.
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.6.0 (2019021500) for Moodle 3.4, 3.5, 3.6
Release date: Friday, 15 Feb 2019
- Implement Privacy API
- Replace deprecated methods:
- htmleditor
- pix_url
- coursecat
- Move JS to AMD modules
- Upgrade some 3rd party JS libraries
- Fix import from XML
- Review the year filter to take min and max years from the calendar factory
- Other fixes and improvements:
- Remove CSS files not found error in JS console
- Show breadcrumbs for users without manage report capability
- Fix DB query function call for the enrolled students filter
- Raise the memory limit when exporting
- Clean some request parameters before using them
- Fix error with user field search box filter
- Improve compatibility with PostgreSQL when importing
Thanks Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several
fixes and improvements.
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this during the project week.
3.1.1 (2016020103) for Moodle 3.0, 3.1
Release date: Monday, 10 Oct 2016
- Fix a critical bug when adding user action/outline statistics, see https://tracker.moodle.org/browse/CONTRIB-4600
Thanks Marina Glancy for the fix
3.1.0 (2016020102) for Moodle 3.0, 3.1
Release date: Wednesday, 25 May 2016
- Several bug fixes
3.0.1 (2016020101) for Moodle 3.0
2.3.9 (2011040121) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Wednesday, 17 Feb 2016
- Fix bug when creating the category list
3.0.0 (2016020100) for Moodle 3.0
Release date: Tuesday, 02 Feb 2016
- Compatible version with Moodle 3.0
2.3.8 (2011040120) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Tuesday, 02 Feb 2016
- Release including bug fixes
2.3.7 (2011040119) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Monday, 03 Aug 2015
- Several bug fixes
- Fixed installation for old moodle versions
- Improved pie chats
Thanks CV&A and Carlos Escobedo for the contribution
2.3.6 (2011040118) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Wednesday, 27 May 2015
- Minor release fixing a regression
Thanks to Dan Marsden for the fix
2.3.5 (2011040116) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Wednesday, 06 May 2015
- Added support for Moodle 2.8 and 2.9
- Added support to the new logging system
- Improved the color palette for graphics with lots of elements
- Allow translations of DataTable strings
- Restored the fsearchuserfield plugin
- Minor issues fixes
Thanks albergasset and jpeak5 for their fixes
2.3.4 (2011040114) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Release date: Thursday, 26 June 2014, 18:16
- New fullname user field column
- Several bug fixes
2.3.3 (2011040113) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Release date: Friday, 13 June 2014, 18:16
- Fixed layout and notice/warnings problems
2.3.2 (2011040110) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6
Release date: Friday, 14 February 2014, 11:14 AM
- Several bug fixes
2.3.2 (2011040109) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6
Release date: Thursday, 30 January 2014, 10:33 AM
- Fixed invalid table reference in cron
2.3.2 (2011040108) for Moodle 2.2, 2.3, 2.4, 2.5m 2.6
Release date Thursday, 16 January 2014, 15:25 AM
- Some bug fixes
- New CSV export
2.3.1 (2011040107) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5m 2.6
Release date Monday, 16 December 2013, 10:25 AM
- Some minor bug fixes
- SQL syntax by default is disabled
- New block instance settings (change name and also show/hide global reports)
- New users cohorts condition
2.3 (2011040106) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5m 2.6
Release date Friday, 13 December 2013, 4:35 PM
- Support for Moodle 2.6
- Multiple bugs fixed
- Global report that can be shared in all courses
- Public reports repository with multiple sample reports available
- Public SQL queries repository
- Reports can run on a different DB that the current (production) DB
- Reports can run on a CRON scheduler
- Several filter plugins added
- Integrated DataTables.js for the report table
- Integrated CodeMirror.js for highlighting SQL query code, while editing.
- New security settings
Thanks to Nadav Kavalerchik for providing most of the new features
2.2 (2011040105) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5
Release date Wednesday, 27 February 2013, 9:35 AM
- Support for Moodle 2.4 and 2.5
- Bugs fixed
2.1 (2011040103) for Moodle 2.0, 2.1, 2.2, 2.3
Release date Friday, 6 July 2012, 1:29 PM
- Support for Moodle 2.3
- Bugs fixed
2.0.2 (2011040102) for Moodle 2.0, 2.1, 2.2
Release date Monday, 9 January 2012, 11:41 AM
- Support for Moodle 2.2
- Bugs fixed
2.0.1 (2011040101) for Moodle 2.0, 2.1
Release date Thursday, 13 October 2011, 12:55 AM
2.0 (2011040100) for Moodle 2.0, 2.1
Release date Thursday, 29 September 2011, 10:47 AM
1.0 (2010090100) for Moodle 1.9
Release date Thursday, 29 September 2011, 10:38 AM
4.1.0 (2023121803)
4.1.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2023121803
Version release name: 4.1.0
Maturity: Stable
Supported Moodle versions: 4.0, 4.1, 4.2
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 4.1.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
4.1.0 (2023120600) for Moodle 4.1
Release date: 06.05.2024
This release focuses on solving issues in Moodle 4.1 and PHP 7.4 and start with small improvements and bug fixes.
- Reformat code
- Add CI testing based on Github Actions created by Catalyst IT
- Add PHP 7.4 support - minimum PHP version is now 7.4
- Add PHP 8.0 support
- Add PHP 8.1 support
- pChart library updated to version 2.4.0
- JS tablesorter library updated to version 2.31.3
- JS CodeMirror library updated to version 5.65.16
- Move repository to https://github.com/Lesterhuis-Training-en-Consultancy/moodle-block_configurablereports
- Original repository (https://github.com/jleyva/moodle-block_configurablereports) can be used for older release or use the old branches within this repository
- removed cr_add_to_log not used anymore
- Important this branch is not backwards compatible with Moodle 3.11 and lower
Thanks to Lesterhuis Training & Consultancy for the contribution / updated by Ldesign Media
- TODOS for the future:
- Namespaces for classes & autoloading
- Move all to
classestoclasses/directory - Clean up code
- Add tests
- AJAX_SCRIPT move to webservice
- unserialize() to json_decode()
- Readme to Markdown format
- validation if a class exists and inherits the correct parent class.
- Changelog to separate file
- Move cron to a scheduled task
- phpcpd and phpdocs checks in CI
- Make CSS strict should only affect this plugin!
3.9.0 (2020110300)
3.9.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2020110300
Version release name: 3.9.0
Maturity: Stable
Supported Moodle versions: 3.10, 3.11, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 3.9.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
3.9.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8, 3.9
Release date: Tuesday, 3 November 2020
- Starting this version for allowing SQL queries performing data insertion/creation the following configuration variable set to 1
is required in your site root /config.php:
$CFG->block_configurable_reports_enable_sql_execution = 1;
Otherwise, previous Custom SQL reports performing data insertion/creation will stop working. - Added matching colors to pie charts
- Added unmapped palette for general colors to pie charts
- Changed fuserfield to allow for multiple instances of the filter
- Added alphabetical sort to courses filter
- Added webservice to get reports data
- Added new filters for competencies
- Other fixes and improvements:
- Fix offset error for bar graphs when not using SQL reporting
- Removed default sorting from DataTables JS UI
- Fixed issue where colors would mismatch if values weren't present
- Fixed STARTTIME and ENDTIME variable substitution
- Avoid text filtering when exporting
Thanks Alex Rowe, David Saylor, Michael Gardener, Muhammad Osama Arshad, Daniel Poggenpohl, Daniel Neis, François Parlant and all the contributors who have sent several fixes and improvements.
3.8.0 (2019122000)
3.8.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2019122000
Version release name: 3.8.0
Maturity: Stable
Supported Moodle versions: 3.4, 3.5, 3.6, 3.7, 3.8
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch: MOODLE_36_STABLE
Repository tag: 3.8.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
- Order the list of users in users filter by fullname considering language - #130
- Other fixes and improvements:
- Fix template array error - #132
- Fix DB mismatch between install.xml and upgrade.php - #123
- Fix LIMIT error for MSSQL - CONTRIB-7891
- Remove "_" from the table header titles - #137
- Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
Thanks Daniel Neis (danielneis), Mike McDougal (mcdoogs), Tuan Ngoc Nguyen (tuanngocnguyen), Mike Henry (mhenry79mnet), safatshahinsd, kristian-94 and all the contributors who have sent several fixes and improvements.
And special thanks also to Carlos, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.3.0 (2019121900)
3.3.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2019121900
Version release name: 3.3.0
Maturity: Stable
Supported Moodle versions: 3.0, 3.1, 3.2, 3.3
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch: MOODLE_33_STABLE
Repository tag: 3.3.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
- Order the list of users in users filter by fullname considering language - #130
- Add a new calculation type: percentage
- Allow userfields to be used more than once in the permissions
- Move JS to AMD modules
- Upgrade some 3rd party JS libraries
- Fix import from XML
- Review the year filter to take min and max years from the calendar factory
- Other fixes and improvements:
- Fix template array error - #132
- Fix DB mismatch between install.xml and upgrade.php - #123
- Fix LIMIT error for MSSQL - CONTRIB-7891
- Remove "_" from the table header titles - #137
- Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
- Fix error when using templates
- Fix error when using the Start/End filter
- Fix legacy_polyfill error when running unit tests
- Display custom title for the block
- Replace deprecated methods (htmleditor, pix_url and coursecat)
- Remove CSS files not found error in JS console
- Show breadcrumbs for users without manage report capability
- Fix DB query function call for the enrolled students filter
- Raise the memory limit when exporting
- Clean some request parameters before using them
- Fix error with user field search box filter
- Improve compatibility with PostgreSQL when importing
Thanks Daniel Neis (danielneis), Mike McDougal (mcdoogs), Tuan Ngoc Nguyen (tuanngocnguyen), Mike Henry (mhenry79mnet), safatshahinsd, kristian-94, David (davidpesce), Dimitrii (dmitriim), Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several fixes and improvements.
And special thanks also to Carlos, Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.7.0 (2019060300)
3.7.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2019060300
Version release name: 3.7.0
Maturity: Stable
Supported Moodle versions: 3.4, 3.5, 3.6, 3.7
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch: MOODLE_36_STABLE
Repository tag: 3.7.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
- Add a new calculation type: percentage
- Allow userfields to be used more than once in the permissions
- Other fixes and improvements:
- Fix error when using templates
- Fix error when using the Start/End filter
- Fix legacy_polyfill error when running unit tests
- Display custom title for the block
Thanks David (davidpesce), Dimitrii (dmitriim) and all the contributors who have sent several fixes and improvements.
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.6.0 (2019021500)
3.6.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2019021500
Version release name: 3.6.0
Maturity: Stable
Supported Moodle versions: 3.4, 3.5, 3.6
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch: MOODLE_36_STABLE
Repository tag: 3.6.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
- Implement Privacy API
- Replace deprecated methods:
- htmleditor
- pix_url
- coursecat
- Move JS to AMD modules
- Upgrade some 3rd party JS libraries
- Fix import from XML
- Review the year filter to take min and max years from the calendar factory
- Other fixes and improvements:
- Remove CSS files not found error in JS console
- Show breadcrumbs for users without manage report capability
- Fix DB query function call for the enrolled students filter
- Raise the memory limit when exporting
- Clean some request parameters before using them
- Fix error with user field search box filter
- Improve compatibility with PostgreSQL when importing
Thanks Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several
fixes and improvements.
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this during the project week.
3.1.1 (2016020103)
3.1.1
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2016020103
Version release name: 3.1.1
Maturity: Stable
Supported Moodle versions: 3.0, 3.1
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 3.1.1
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fix a critical bug when adding user action/outline statistics, see https://tracker.moodle.org/browse/CONTRIB-4600
Thanks Marina Glancy for the fix
3.1.0 (2016020102)
3.1.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2016020102
Version release name: 3.1.0
Maturity: Stable
Supported Moodle versions: 3.0, 3.1
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 3.1.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Several bug fixes
2.3.9 (2011040121)
2.3.9
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040121
Version release name: 2.3.9
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 2.3.9
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fix bug when creating the category list
3.0.1 (2016020101)
3.0.1
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2016020101
Version release name: 3.0.1
Maturity: Stable
Supported Moodle versions: 3.0
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 3.0.1
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fix bug when creating the category list
2.3.8 (2011040120)
2.3.8
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040120
Version release name: 2.3.8
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 2.3.8
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Release including bug fixes
3.0.0 (2016020100)
3.0.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2016020100
Version release name: 3.0.0
Maturity: Stable
Supported Moodle versions: 3.0
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag: 3.0.0
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Version compatible with Moodle 3.0
2.3.7 (2011040119)
2.3.7
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040119
Version release name: 2.3.7
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
- Several bug fixes
- Fixed installation for old moodle versions
- Improved pie chats (thanks CV&A and Carlos Escobedo for the contribution)
2.3.6 (2011040118)
2.3.6
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040118
Version release name: 2.3.6
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Minor release fixing a regression (thanks to Dan Marsden for the fix)
2.3.6 (2011040117)
2.3.6
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040117
Version release name: 2.3.6
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Several fixes:
Cron task
Github settings
Added 'in' textfilter operator
Add bar chart support (using pChart2)
Thanks Brad Smith, Anthony Kuske and leonstr for their contributions
2.3.5 (2011040116)
2.3.5
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040116
Version release name: 2.3.5
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
- Added support for Moodle 2.8 and 2.9
- Added support to the new logging system
- Improved the color palette for graphics with lots of elements
- Allow translations of DataTable strings
- Restored the fsearchuserfield plugin
- Minor issues fixes
Thanks albergasset and jpeak5 for their fixes
2.3.4 (2011040115)
2.3.4
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040115
Version release name: 2.3.4
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Several bug fixes
2.3.3 (2011040114)
2.3.3
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040114
Version release name: 2.3.3
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
New fullname user field column
Several bug fixes
2.3.3 (2011040113)
2.3.3
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040113
Version release name: 2.3.3
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fixed layout and notice/warnings problems
2.3.3 (2011040112)
2.3.3
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040112
Version release name: 2.3.3
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fixed connection problems due to remoteDB incorrect initialization
2.3.3 (2011040111)
2.3.3
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040111
Version release name: 2.3.3
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Added support for Moodle 2.7
Added new user column plugin (final grade in current course)
Added options for limit the max number of records in SQL queries (previously the limit was hard coded to 5000)
2.3.2 (2011040110)
2.3.2
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040110
Version release name: 2.3.2
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Course name support multi lang tags
Fixed problem in user field condition
2.3.2 (2011040109)
2.3.2
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040109
Version release name: 2.3.2
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fix bug in cron task for SQL reports
2.3.1 (2011040108)
2.3.1
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040108
Version release name: 2.3.1
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
New user course completion column
New settings for displaying the list of the reports in the block body (or not)
2.3.1 (2011040107)
2.3.1
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040107
Version release name: 2.3.1
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Some minor bug fixes
SQL syntax by default is disabled
New block instance settings (change name and also show/hide global reports)
New users cohorts condition
2.3 (2011040106)
2.3
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040106
Version release name: 2.3
Maturity: Stable
Supported Moodle versions: 2.2, 2.3, 2.4, 2.5, 2.6
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Support for Moodle 2.6
Multiple bugs fixed
Global report that can be shared in all courses
Public reports repository with multiple sample reports available
Ppublic SQL queries repository
Reports can run on a different DB that the current (production) DB
Reports can run on a CRON scheduler
Several filter plugins added
Integrated DataTables.js for the report table
Integrated CodeMirror.js for highlighting SQL query code, while editing.
New security settings
Thanks to Nadav Kavalerchik for providing most of the new features
2.2 (2011040105)
2.2
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040105
Version release name: 2.2
Maturity: Stable
Supported Moodle versions: 2.0, 2.1, 2.2, 2.3, 2.4, 2.5
Repository URL (Git): https://github.com/jleyva/moodle-block_configurablereports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Multiple bugs fixes and improvements
See https://github.com/jleyva/moodle-block_configurablereports/commits/MOODLE_21_STABLE starting 6th June 2012
2.1 (2011040103)
2.1
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040103
Version release name: 2.1
Maturity: Stable
Supported Moodle versions: 2.0, 2.1, 2.2, 2.3
Repository URL (Git): http://cvs.moodle.org/contrib/plugins/blocks/configurable_reports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Configurable Reports Block
Installation, Documentation, Tutorials....
See http://docs.moodle.org/en/blocks/configurable_reports/
Also http://moodle.org/mod/data/view.php?d=13&rid=4283
Author: Juan Leyva
http://moodle.org/user/profile.php?id=49568
http://twitter.com/jleyvadelgado
http://sites.google.com/site/mooconsole/
http://moodle-es.blogspot.com
http://openlearningtech.blogspot.com
Thanks to:
Ivan Breziansky for translating the block to slovak language
Iñaki Arenaza for translating the block documentation to spanish
Luis de Vasconcelos for testing the block
Adam Olley and Netspot Moodle Partner for improving some parts of the Moodle2 version
Some parts of this plugin uses code of:
Admin Report: Custom SQL queries
http://moodle.org/mod/data/view.php?d=13&rid=2884
By Tim Hunt
2.0.2 (2011040102)
2.0.2
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040102
Version release name: 2.0.2
Maturity: Stable
Supported Moodle versions: 2.0, 2.1, 2.2
Repository URL (Git): http://cvs.moodle.org/contrib/plugins/blocks/configurable_reports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
Fixed lot of small issues
2.0.1 (2011040101)
2.0.1
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040101
Version release name: 2.0.1
Maturity: Stable
Supported Moodle versions: 2.0, 2.1
Repository URL (Git): http://cvs.moodle.org/contrib/plugins/blocks/configurable_reports/
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
2.0 (2011040100)
2.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2011040100
Version release name: 2.0
Maturity: Stable
Supported Moodle versions: 2.0, 2.1
Repository URL (Git): https://jleyva@github.com/jleyva/moodle-block_configurablereports.git
Repository branch: MOODLE_21_STABLE
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22
1.0 (2010090100)
1.0
Plugin type: Blocks
Frankenstyle component name: block_configurable_reports
Version build number: 2010090100
Version release name: 1.0
Maturity: Stable
Supported Moodle versions: 1.9
Repository URL (Git):
Repository branch:
Repository tag:
Issue/bug tracker URL: https://tracker.moodle.org/issues/?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A+Configurable+report%22