In the Query String field, enter the following query:
select id, name, concat(repeat(concat(' ', char(59 using utf8)), (depth-1)*2), name) as hierarchy_name from mdl_course_categories order by sortorder |
click the Save button. The Save Parameters page appears:
In the Value Column field, enter "id". This enables the Input Control window to present values based on the ID fields from the mdl_course_categories table.
In the Visible Columns field, enter "name" and click the Add button. This enables the Input Control window to present the ID fields by their associated name. In this case, this will display the Course Categories by their proper names instead of their IDs.
Click the Submit button.
Proceed to Creating the Cascading Courses Input Control.