General developer forum

All course wise reports

Picture of Kumar k
All course wise reports


I want to generate all  course wise reports (completed, incompleted) using ad-hock quries.

I am usig Ad-hoc database queries pluggin(

is this right Pluggin for generate ad-hock reports.

 can any one provide right query. Right now iam using below query but no result given








 DATE_FORMAT(FROM_UNIXTIME(p.timecompleted),'%Y-%m-%d') AS completed

FROM prefix_course_completions AS p

JOIN prefix_course AS c ON p.course =

JOIN prefix_user AS u ON p.userid =

WHERE c.enablecompletion = 1

ORDER BY u.username"


Average of ratings: -