Hi Ray,
Apologies for the late reply. Like you suggested, I changed
JOIN mdl_assign_grades AS ag ON ag.`userid`=u.`id`
to
JOIN mdl_assign_grades AS ag ON (ag.`userid`=u.`id` AND a.id = ag.assignment)
As a result the feedback repetition is removed so as some users too.
For example after I changed the JOIN, user Kumar is removed. I changed GROUP to ORDER because the users will be attending assessment in more than one course. So If I GROUP them, rest of the courses will be ignored, right?
Let me try with more specific conditions
Thank you
Apologies for the late reply. Like you suggested, I changed
JOIN mdl_assign_grades AS ag ON ag.`userid`=u.`id`
to
JOIN mdl_assign_grades AS ag ON (ag.`userid`=u.`id` AND a.id = ag.assignment)
As a result the feedback repetition is removed so as some users too.
For example after I changed the JOIN, user Kumar is removed. I changed GROUP to ORDER because the users will be attending assessment in more than one course. So If I GROUP them, rest of the courses will be ignored, right?
Let me try with more specific conditions
Thank you