Hello,
Today I installed the plugin and I tried to run the one named SITE WIDE COMPLETED SCORM ACTIVITIES (see below the code). I would like to improve it in order to have also the information of two status:
a) Not started
b) in progress
I have no idea about coding so I need a bit of help.
Thanks a lot
Andrea
SELECT u.id ID,u.firstname FIRST,u.lastname LAST,u.email EMAIL, u.city CITY,u.country COUNTRY,c.fullname Course, st.attempt Attempt,st.VALUE STATUS,FROM_UNIXTIME(st.timemodified,"%m-%d-%Y") DATE
FROM prefix_scorm_scoes_track AS st
JOIN prefix_user AS u ON st.userid=u.id
JOIN prefix_scorm AS sc ON sc.id=st.scormid
JOIN prefix_course AS c ON c.id=sc.course
WHERE st.VALUE='completed'
ORDER BY u.email,c.fullname, u.lastname,u.firstname, st.attempt