Hallo,
Onderstaande query werkt prima in Configurable Reports, maar krijg ik niet aan de praat in query m.b.v.
$DB->get_records_sql
SELECT u.firstname AS 'First', u.lastname AS 'Last', q.name AS 'Quiz',
convert(FROM_UNIXTIME(qa.timefinish),datetime) as LastSubmission,
concat( '%%WWWROOT%%/mod/quiz/report.php?id=',
cm.id,
'&mode=gradingstudents&usageid=',
qa.uniqueid,
'&slots=',
( SELECT group_concat(qua.slot SEPARATOR '%2C')
FROM prefix_question_attempts as qua
WHERE qua.questionusageid = qa.uniqueid
AND qua.behaviour = 'manualgraded'),
'&grade=needsgrading',
'') AS 'GradeLink'
FROM prefix_course AS c
JOIN prefix_course_modules AS cm ON c.id = cm.course
JOIN prefix_enrol AS en ON en.courseid = c.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_quiz AS q ON c.id = q.course
JOIN prefix_quiz_attempts AS qa ON q.id = qa.quiz
JOIN prefix_user AS u ON u.id = qa.userid
WHERE cm.instance = q.id
AND ue.userid = u.id
AND cm.module = '16'
AND c.id = '%%COURSEID%%'
AND qa.timefinish > 0
AND qa.sumgrades is NULL
ORDER BY LastSubmission