Hi there! I want create reports where only manual grades. I fouded report "List courses with MANUAL grades" :
SELECT COUNT( * )
,concat('<a target="_new" href="%%WWWROOT%%/grade/edit/tree/index.php?showadvanced=1&id=',c.id,'">',c.fullname,'</a>') AS Course
FROM prefix_grade_items AS gi
JOIN prefix_course AS c ON c.id = gi.courseid
WHERE `itemtype` = 'manual'
GROUP BY courseid
How I can create it?