I need to see all posts by a student, including replies, as well as "new topics".
In the class I have 6 units of study. Each unit has its own forum.
I have been studying php and mysql this winter but I must confess to being rather intimidated by the large collection of tables and by joining tables. I'm thinking I need at least three tables:
mdl_forum_discussions
mdl_user_students
mdl_users
I think that somehow I need to "join" these tables together so I can generate a report that will show me their posts.
For a given class, not sure how to identify the specific class for the script ...
list each enrolled student, then list each forum and for each forum list every post they have made, noting which iis an original post and which a reply (in that individual forum)
Any thoughts? It needn't be specially formatted, a very plain listing would be fine.
many thanks!
Displaying all posts by a student
Number of replies: 2Re: Displaying all posts by a student
There is a report that will give you this information, just not in detail.
If you have 1.2 Beta or later:
Click the "Full report of recent activity ... " link found in the Recent activity block on a courses main page. If you select the "Advanced filter" link, you can select "All forums" for a particular user.
If you are wanting a detailed listing let me know.
(http://www.moodle.org has this feature already on it, so you can play with it if you don't have 1.2 Beta.)
If you have 1.2 Beta or later:
Click the "Full report of recent activity ... " link found in the Recent activity block on a courses main page. If you select the "Advanced filter" link, you can select "All forums" for a particular user.
If you are wanting a detailed listing let me know.
(http://www.moodle.org has this feature already on it, so you can play with it if you don't have 1.2 Beta.)
Re: Displaying all posts by a student
Thanks scott, this makes a nice report. Also, playing around with activity logs I find I can get the posts even in the older moodle. I appreciate your help!
paula
paula