Not sure whether to post here or in the Forum forum...
I would like to query the Moodle (3.1, 3.2) database to get the following data in a specified course for a specified discussion forum.
1. For every pair of users in the course, user-A and user-B, how many times did user-B reply to a post of user-A (no matter if it was to a new base note or a reply), and vice versa. (Researching connectedness and symmetry of users in Forums.)
2. How many times did each user post (whether a new topic or a reply) to anyone else in the course. (Level of activity).
3. What was the average rating that each user received (whether for a topic or for a reply) (Quality of activity as measured by peers).
Can anyone point me to the right queries that would do the above, or which I could use as a starting point for development?
Thanks,
Alan