Hola necesito ayuda con una consulta sql para el bloque Configurable Reports.
Quiero hacer un informe que me indique las tareas que están esperando a ser calificadas. He copiado de esta página la siguiente consulta:
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course
,(SELECT Count( ra.userid ) AS Users
FROM prefix_role_assignments AS ra
JOIN prefix_context AS ctx ON ra.contextid = ctx.id
WHERE ra.roleid = 5
AND ctx.instanceid = c.id
) AS Students
,(
SELECT count(qz.id)
FROM prefix_quiz AS qz
JOIN prefix_course_modules AS cm ON qz.course = cm.course
WHERE cm.instance = qz.id AND cm.module = 12 AND qz.course = c.id
) nQuizzes
,(
SELECT count(a.id)
FROM prefix_assignment AS a
JOIN prefix_course_modules AS cm ON a.course = cm.course
WHERE cm.instance = a.id AND cm.module = 1 AND a.course = c.id
) nAssignments
,(
SELECT count(asb.id)
FROM prefix_assignment_submissions AS asb
JOIN prefix_assignment AS a ON a.id = asb.assignment
JOIN prefix_course_modules AS cm ON a.course = cm.course
WHERE asb.grade < 0 AND cm.instance = a.id AND cm.module = 1 AND a.course = c.id
) unCheckedAssignments
,(
SELECT count(asb.id)
FROM prefix_assignment_submissions AS asb
JOIN prefix_assignment AS a ON a.id = asb.assignment
JOIN prefix_course_modules AS cm ON a.course = cm.course
WHERE cm.instance = a.id AND cm.module = 1 AND a.course = c.id
) SubmittedAssignments
FROM prefix_course AS c
WHERE 1=1
%%FILTER_YEARS:c.fullname%%
## You can enable the SEMESTER filter as well,
## by uncommenting the following line:
## %%FILTER_SEMESTERS:c.fullname%%
Al ponerla en el bloque me da el siguiente error:
ERROR: Número incorrecto de parámetros de consulta. Se esperaban 1, se tienen 0.
¿Alguien me puede ayudar?
Un saludo