Greetings,
I'm trying to create a dashboard SQL report (Moodle 2.9) that returns the course name, course id, turnitin assignment name, turnitin assignment id, and turnitin assignment introduction. I reviewed the tables and came up with the following SQL:
SELECT c.shortname, c.id as "Course ID", t.name as "Assignment Name", t.intro FROM mdl_turnitintool t INNER JOIN mdl_course c ON c.id = t.id WHERE c.category = 497 AND (c.shortname LIKE '%ACC%' OR c.shortname LIKE '%BSM%' OR c.shortname LIKE '%BUS%' OR c.shortname LIKE '%CIS%' OR c.shortname LIKE '%ECO%' OR c.shortname LIKE '%MGT%') GROUP by c.shortname
It returns courses WITH turnitin assignments and courses without turnitin assignments. What in the heck am I doing wrong?
Thanks for the assistance everyone!