Hola, utilizo la versión 3.4.1 de Moodle.
Estoy intentado desarrollar unos informes en SQL, quiero crear un filtro para un curso determinado, copio mi informe;
SELECT
users.username,
CONCAT(users.lAStname, ', ',users.firstname) AS "Full Name",
courses.fullname AS "Course Name",
ROUND(grades.finalgrade, 2) AS "Total Grade",
CASE
WHEN grades.finalgrade > 90 THEN 'Excellent'
WHEN grades.finalgrade > 70 THEN 'PASsed'
WHEN grades.finalgrade > 0 THEN 'Failed'
WHEN grades.finalgrade = 0 THEN 'Incomplete'
ELSE 'N/A'
END AS "Remarks"
FROM prefix_user AS users
INNER JOIN prefix_grade_grades AS grades ON grades.userid = users.id
LEFT OUTER JOIN prefix_grade_items AS gradeitems ON grades.itemid = gradeitems.id AND gradeitems.itemtype = 'course'
INNER JOIN prefix_course AS courses ON courses.id = gradeitems.courseid
WHERE 1=1
%%FILTER_COURSES:courses.id%%
ORDER BY courses.sortorder, users.lAStname ASC
Mi idea es que solo me saque las calificaciones y usuarios de un solo curso en concreto, por ejemplo, ASCENSORES.
Gracias, saludos.