Hi Derek et al,
I've been playing with the Ad-Hoc reports and had problems with pulling the attendance score (grade) from the attfor block(It always showed 100%) but discovered that its easier to pull the "grade" from the gradebook where the calculation is correct.
This code below works for me - use at your own risk...I'm an amateur.
You may want to add dates/categories etc.
Regards,
V
SELECT
prefix_user.username,
prefix_user.firstname,
prefix_user.lastname,
prefix_grade_grades.rawgrade AS 'Attendance_Score',
prefix_grade_grades.rawgrademax,
prefix_grade_grades.rawgrademin,
prefix_course.fullname,
prefix_course_categories.`name` AS 'CategoryName'
FROM
prefix_grade_grades
INNER JOIN prefix_grade_items ON prefix_grade_grades.itemid = prefix_grade_items.id
INNER JOIN prefix_user ON prefix_user.id = prefix_grade_grades.userid
INNER JOIN prefix_course ON prefix_course.id = prefix_grade_items.courseid
INNER JOIN prefix_course_categories ON prefix_course_categories.id = prefix_course.category
WHERE prefix_grade_items.itemname = "Attendance"