Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Moodle courses that have used inline PDF annotation feedback -thanks, mackensen
SELECT DISTINCT name as "Assignment Name", course as "Course ID", fullname as "course title", "Standard" as "Annotation"
FROM prefix_assignfeedback_editpdf_annot ant
INNER JOIN prefix_assign_grades grd ON ant.gradeid = grd.id
INNER JOIN prefix_assign assign ON grd.assignment = assign.id
INNER JOIN prefix_course c ON assign.course = c.id
UNION
SELECT DISTINCT name as "Assignment Name", course as "Course ID", fullname as "course title", "Comment" as "Annotation"
FROM prefix_assignfeedback_editpdf_cmnt cmnt
INNER JOIN prefix_assign_grades grd ON cmnt.gradeid = grd.id
INNER JOIN prefix_assign assign ON grd.assignment = assign.id
INNER JOIN prefix_course c ON assign.course = c.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.