Hi everybody,
I'd like to know if it's posible and how can I filter a course report by group.
Any toughts?
Daniel
Have you set the course settings to separate groups mode?
I tried different course settings but couldn't see any change on my report. Thank's anyway.
So is this not possible?
I am trying to create a report with the user activity of the student in a specific group...
Not possible, sorry:
See: http://docs.moodle.org/22/en/Configurable_reports#How_to_request_a_new_feature for requesting a new feature
Hi Daniel, is not posible to filter course reports by groups.
There is no such plugin
Why do you need this filter? I mean, a course report show a list of courses. Why you want to filter per groups inside this courses?
I suppose the groups has the same name between courses
Regards
Well in the "Grades" section of a course, you can view various reports about each user. And if your course supports groups, you can ALSO filter those reports by group.
I believe that is why the previous poster was asking if your plugin could also filter by groups.
I would like to do the same as well with your reports: find the group the user belongs to. Is this currently not possible?
Hi Juan,
Sorry for the delay, unstable dates... BTW happy new year!
For instance, I need a report to show wich users have downloaded their certificates and the teacher needs this report filtered by group.
Some advice?
TIA
Hi Daniel,
Me too i am looking disperatly for a solution to this.
I need the teacher to only see his group members when he clicks on the report ..
Please let me know if you find any way arround.
thank you
Hi there,
I was wondering did anyone ever get a work around for this?
Thanks,
Darren
This isn't specifically a filter by group but can be once downloaded to Excel but I run this enrolment report that pulls group membership. Hopefully you can pull out the group stuff and adjust it for one of your reports.
SELECT DISTINCT c.shortname, usr.firstname, usr.lastname, usr.city, groups.name
FROM mdl_course AS c
INNER JOIN mdl_context AS cx ON c.id = cx.instanceid
AND cx.contextlevel = '50'
AND c.category = '4'
INNER JOIN mdl_role_assignments AS ra ON cx.id = ra.contextid
INNER JOIN mdl_role AS r ON ra.roleid = r.id
INNER JOIN mdl_user AS usr ON ra.userid = usr.id
INNER JOIN mdl_groups AS groups ON c.id = groups.courseid
INNER JOIN mdl_groups_members AS members ON groups.id = members.groupid
WHERE members.userid = usr.id
AND r.name = "Student"
ORDER BY groups.nameHi Emma,
Thank you for taking the time to reply, it is very much appreciated. I will give the above a go.
Thanks again,
Darren