Retreive list of students registered for a particular course

Posted by Pankaj Khurana on Stack Overflow See other posts from Stack Overflow or by Pankaj Khurana
Published on 2010-06-08T07:57:47Z Indexed on 2010/06/08 8:02 UTC
Read the original article Hit count: 252

Filed under:

moodle

Hi,

I have moodle1.9 installed on my system and writing some custom reports.

I want to retrieve list of students registered for a particular course.

I have user profile field usercategoryid through which i figure out for which category he has enrolled. Course belongs to a particular category.

Through mdl_user_info_data table i retrieve the category for a particular user.

I have written a query to retrieve the users who have registered for a particular category for e.g. Financial Planning 2010. But the issue is that i now want users who have registered for a particular course for e.g. Insurance Planning. There is a relation between course and course category but i am unable to find out the table where course and user information is linked.

Please help me on this

Thanks

Related posts about moodle

Moodle course setup workflow

as seen on Stack Overflow - Search for 'Stack Overflow'
i would like the student to view the lessons in an order. for example topic 3 should not accessible until the student completes topic 2. -Vivek >>> More
Office add on saves you time if you use Moodle

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Moodle is a free elearning content management software program. It does take a great deal of time to set it up because you need to upload your Office files to Moodle. Now, Microsoft has made that job easier with their new Office Add on. With it you can save directly into Moodle. Here are the instructions… >>> More
Install Moodle to subdomain with Softaculous via cPanel

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I installed Moodle to a directory with Softaculous. Since it doesn't allow installing to a subdomain, after installing it I created a subdomain and pointed the destination (of the subdomain) to the previously created Moodle directory. Now when I go to the subdomain.example.com it says Incorrect… >>> More
Moodle Inconsistencies, Flowplayer, or Server?

as seen on Pro Webmasters - Search for 'Pro Webmasters'
We are trying to decide if an issue we're having with Moodle and our videos is a flowplayer issue, a video issue, or a network issue. Any input is welcome. We've had videos in our Moodle (version 1.9, we're working on an upgrade on a different server) up for weeks, or even months. After that time… >>> More
Linux Server hacked?

as seen on Server Fault - Search for 'Server Fault'
I'm trying to determine if this linex webserver/openfire server has been compromised by some form of malware or a hacker. Can you please help me determine if this server has been hacked? The snippet of logs below are from the linux server running apache. A few days ago the moodle site, which is installed… >>> More

Developer IT