SQL code: report for one course only

Re: SQL code: report for one course only

by Randy Thornton -
Number of replies: 0
Picture of Documentation writers

Nice.

Also, if you are using Configurable Reports you could add a filter to this so you could choose your course from a dropdown list.

So:

WHERE  (gi.courseid = c.id AND gi.itemname != 'Attendance') 
%%FILTER_COURSES:c.id%%
And then on the report's Filters tab, add the "Courses" filter.
Average of ratings: -