Get list of all active students in course

[makarand]

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]

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]

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

[makarand]

@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]

@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