Can anyone help me. I have been playing with PYP trying to understand what data is in what tables and how they relate. I have run into a problem.
Our user are in the mdl_user table. This table contains the mdl_user.id field.
Our historical data is in the mdl_log. I can query by mdl_log.userid (this is the same data as the mdl_user.id), The mdl_log also has the mdl_log.course field (this field shows the tbl_mdl_course.id field) By creating a join between the mdl_log and the mdl_course tables I can view the course and individual viewed and the time they did it.
Here is my problem. I need to built a query that will show me the individuals enrolled in a particular course. I can't seem to find a record that would show the Student userid's enrolled in a particular course.
Can anyone help me?
