Get list of all active students in course

[Makarand Mane]

Hi I want to get list of all active students in course (Whose course status is active and not expired.) I used this function bp_course_get_students_undertaking( $course_id ); It returns all student under course. Is there another function in WPLMS which return only active students?

[logan]

hello, please have a look on the developers guide: https://vibethemes.github.io/wplms-docs/developer-guide.html

[Makarand Mane]

Hi I have already bookmarked that link. but I didn't get function I need as described above. If you know other ready function bp_course_get_students_undertaking from WPLMS then let me know. wplms_user_course_active_check function check status. But I want to fetch list of students who are active and on current course, how I can get it in one query?

[Diana]

@makarand In LMS > Statistics Section, in students tab we are showing active students as well. So, you need to check the statistics code. Please check vibe customtypes plugin > statistics.php This Function lms_stats_student_content

[Makarand Mane]

@Diana I am not asking who is active on website. I need list of students for course who have access to class.

[Makarand Mane]

@diana Here is solution I was looking for

global $wpdb;
$query = $wpdb->prepare( "SELECT user_id FROM {$wpdb->usermeta} WHERE meta_key = %d AND meta_value > UNIX_TIMESTAMP( NOW() )", $course_id );
return $wpdb->get_col( $query );

[Veronica]

so it's showing all active students. as you find the way to show it. can we close the topic?

[Makarand Mane]

@veronica & @diana with closing ticket, please note that, understand question & reply. None of you gave a proper reply and my lot of time was waste here.

[logan]

Ohh dear Friend, i will ensure that they will be more supportive. much respect :) logan support head - vibe team

[Author]

Posts