moodle

Moodle Student list with Groups and Course


I am using moodle2.4.6. I want a list of user with their groups and their courses.


Solution

  • You will need to do an SQL query to get this information.

    Assuming you are using the default 'mdl_' prefix for tables, you will need to join together the following tables:

    Please comment if you need help turning that pseudo code into actual SQL, or if you need help with the Moodle database access API ( http://docs.moodle.org/dev/Data_manipulation_API )