I have about five different feedback activity inside a course, all the five feedback activities have the same set of questions.
Q1. Are you happy with the lecture video? Yes/No
Q2. Did you understand the concept? Yes/No
What I am trying to is to get a cumulative summary of all the five feedback activities of all the students.
I tried this query this query with out much luck
SELECT crs.fullname as "Course name", f.name AS "Journal name", CONCAT(u.firstname,' ',UPPER(u.lastname)) as "Participant", /* include these fields if you want to check the composition of the recordset */
DATE_FORMAT(FROM_UNIXTIME(c.timemodified),'%W %e %M, %Y') AS "Answer Date",
CASE i.typ WHEN 'label' THEN i.presentation ELSE i.name END AS "Topic", /* usually labels are used as section titles, so you'd want them present in the recordset */
v.value AS "My Answer"
FROM prefix_feedback AS f
INNER JOIN prefix_course AS crs ON crs.id=f.course %%FILTER_COURSES:f.course%%
INNER JOIN prefix_feedback_item AS i ON f.id=i.feedback
INNER JOIN prefix_feedback_completed AS c ON f.id=c.feedback %%FILTER_COURSEUSER:c.userid%%
LEFT JOIN prefix_feedback_value AS v ON v.completed=c.id AND v.item=i.id
INNER JOIN prefix_user AS u ON c.userid=u.id
WHERE c.id = %%COURSEID%% /* This clause limits the recordset to the current course and the current user and includes/ excludes the anonymous responses as needed */
ORDER BY f.id, c.timemodified, i.id
Please help me out.