Hi, can anyone help me? The report Code is attached as well as the grader screen shot showing the 2 assessments.
I am not an SQL expert and so don't know the database fields I need to create the report I need.
I am writing a report for a Moodle course that has two assessments.
At the moment, I can get a certificate but it is for the whole course.
Code is:
WHERE gi.courseid = c.id
AND c.shortname = "Smokefree MH&AS"
AND gi.itemtype <> 'course'
AND gg.finalgrade >= gi.gradepass
AND u.id=%%USERID%%
%%FILTER_STARTTIME:gg.timemodified:>%% %%FILTER_ENDTIME:gg.timemodified:<%%
I want the report to give a certificate if the student passes Module1 and one if the student passes Module2 as they don't all do both modules.
I hope this makes sense and someone can shed some light.
Let me know if you need any other information.
Ross
