When trying to list courses by department, users will not be able to select the specific department name from the list of criteria. Users will instead need to use the department ID.
To list courses based on department you will need to use the department ID. This can not be found by looking up the department as this is a unique identifier that is located in the back end of the software. Follow the steps below to successfully filter on certain departments when creating an advanced list.
1. Start with a new advanced list or a list template. 2. On the objects tab expand Academic Groups and add Course Base and Course Group. 3. Add Course Department and Academic Department.
4. Go to Display Fields > Select Fields... 5. Expand Course Group > Course Base > Course Department > Academic Department > Department Id (At this point it may be good to add Course Name, etc from under Course Detail.) 6. Click Preview 7. Review the list of courses and locate a course that falls under the desired department. Make a note of the Department ID as you will want to use that in your filters.
8. Go to the Filters tab 9. Under Object Filters add a row for Academic Department.Department ID 10. In the Condition window choose equal to and enter the Department ID.
(The image above shows how this would be set up if multiple departments should be included in the Advanced List.) 11. Add any additional filters or display fields and preview results. 12. Save & Exit