Using Moodle 3.4 and configurable repoprts I want to use a "Course-Filter". I set that up, but the Dropdown-List now shows ALL courses in my moodle. The visible ones AND the hidden ones.
Of course I only want to see the visible ones in the Filter-Drop-Down.
How can one manage that?
Thanks
Rolf
I found a solution in an older thread:
File: configurable_reports/components/filters/courses/plugin.class.php:
comment 3 lines in original code: ************* START (about line 78)
// if (!empty($courselist)) {
// list($usql, $params) = $remotedb->get_in_or_equal($courselist);
// $courses = $remotedb->get_records_select('course', "id $usql", $params);
and replace by:
if(!empty($courselist)){
list($usql, $params) = $remotedb->get_in_or_equal($courselist);
$sort='fullname'; //to sort course by name
$select='visible=1'; //to only show those that are visible
$courses = $remotedb->get_records_select('course', $select, $params, $sort);
...
Does the trick.
Now in course-list only visible courses are listed.
