Path: Reporting > Ad Hoc Reporting > Filter Designer
The following queries relate to course and/or section information and require that the Course/Section radio button be selected on the main Filter Designer page.
These sample queries are for example purposes only. They are a starting point for understanding how to use this tool. Requests to design, modify, or troubleshoot a Pass-Through Query are subject to a fee
Courses without Assigned Grading Tasks
This query returns courses to which a grading task has not yet been assigned.
Box A
LEFT OUTER JOIN gradingtaskcredit gtc ON gtc.courseID = course.courseID AND gtc.calendarID = course.calendarID
Box B
AND gtc.taskCreditID IS NULL
Courses without Sections
This query returns courses to which a section has not yet been assigned.
Box A
LEFT OUTER JOIN [Section] s ON s.courseID = course.courseID AND course.active = 1 LEFT OUTER JOIN Trial tr on tr.trialID = s.trialID AND tr.active = 1
Box B
AND s.sectionID IS NULL
Courses without Categories
This query returns a list of courses that are not assigned any categories.
Box A
LEFT JOIN lessonplangroupCourse lpc ON lpc.courseid = course.courseid
Box B
AND lpc.courseID is null
Courses without Grade Calc Options
This query returns a list of courses that are not assigned any grade calc options.
Box A
LEFT JOIN lessonplanpreferencecourse lpc ON lpc.courseid = course.courseid
Box B
AND lpc.courseID is null
