| Server IP : 165.22.154.248 / Your IP : 216.73.217.0 [ Web Server : Apache/2.4.29 (Ubuntu) System : Linux droplet-integra 4.15.0-197-generic #208-Ubuntu SMP Tue Nov 1 17:23:37 UTC 2022 x86_64 User : www-data ( 33) PHP Version : 7.2.24-0ubuntu0.18.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals, Domains : 1 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/avanza-lms.old.bak9874115/report/customsql/ |
Upload File : |
# Change log for the Ad-hoc database queries report ## Changes in 3.8 * Report results can now be downloaded in any of data format that Moodle supports, not just CSV. * Admins can control the maximum possible limit for the number of rows a query can return. * Admins can now set which day is considered the first of the week for weekly reports. This defaults to the Moodle setting for this for new installs. For existing installs, it stays the same as before (Saturday) but you can change it. ## Changes in 3.7 * If a report has query parameters, they can now be set in the URL (GET parameters) so you can bookmark a particular variant of a report. * There is a parameter you can add to the URL of a report, so it is displayed with 'embedded' page layout, suitable for showing in an iframe. * Also, change the page layout used in the normal case to 'report'. * Query param values that are integers are now sent to the database as integers, which can lead to queries being optimised better. * Fix an issue with showing the results of scheduled reports, when the report only produces data sometimes. * Improve handling of 'pretty' column names. * Fix compatibility with the messaging API changes in Moodle 3.6. * Improve message default settings on install. * Move hard-coded English string 'Run report' to the language file. ## Changes in 3.6 * New feature for columns that are links. If the SQL query returns two columns `name` and `name_link_url` (for any value of `name`) then the that will be shown as a single column of links, where the visible link text comes from the `name` column, and the URL comes from the `name_link_url` column. * The exact case of the column titles is extracted from the query. So, if your query is `SELECT 'x' AS My_HTML`, previously the table would display the column heading as 'my html'. Now it will show 'My HTML'. * A summary of the number of rows output under the table. * Moodle 3.3 compatibility re-established thanks to Paul Holden. * Behat tests fixed for Moodle 3.6. ## Changes in 3.5 * Privacy API implementation. * Fix escaping of values in reports that contain HTML special characters. * Fix bug where the report name was missing from scheduled task emails. * Fix some coding style issues. * Due to privacy API support, this version now only works in Moodle 3.4+ For older Moodles, you will need to use a previous version of this plugin. ## 3.4 and before Changes were not documented here.