Hi,
I need to build a report that contain all the grades and presence of students,
I need to do it using this plugin because I need all the filter that this plugin has.
Does anyone knows if there something like that already?
Thanks
Raphael,
You need to look at the lists of sql contributed reports and then adapt it your precise needs.
This query may get you started:
SELECT
prefix_user.city AS PSA,
prefix_user.lastname,
prefix_user.firstname,
prefix_grade_items.itemname,
ROUND(prefix_grade_items.grademax, 0) AS maxgrade,
ROUND(prefix_grade_grades.finalgrade, 0) AS finalgrade,
DATE_FORMAT( FROM_UNIXTIME( prefix_grade_grades.timemodified) , '%m/%d/%Y' ) AS DATE
FROM
prefix_grade_grades
INNER JOIN prefix_user ON prefix_grade_grades.userid = prefix_user.id
INNER JOIN prefix_grade_items ON prefix_grade_grades.itemid = prefix_grade_items.id
WHERE (prefix_grade_items.itemname IS NOT NULL)
AND (prefix_grade_items.itemtype = 'mod' OR prefix_grade_items.itemtype = 'manual')
AND (prefix_grade_items.itemmodule = 'quiz' OR prefix_grade_items.itemmodule IS NULL)
AND (prefix_grade_grades.timemodified IS NOT NULL)
AND (prefix_grade_grades.finalgrade > 0)
AND (prefix_user.deleted = 0)
ORDER BY `City` ASC, prefix_user.lastname
It is a nice start, thanks.
Is it possible to have all the activities in columns and each row will contain all the grades of each students?
Thanks