Changes between Version 2 and Version 3 of ViewingEnrolledStudents

Timestamp:

01/22/26 04:04:17 (15 hours ago)

Author:

221296

Comment:

--

ViewingEnrolledStudents

@@ -5 +5 @@
 **1.** The instructor opens the Overview for a specific course.
 
-**2.** The system generates a report with enrolled users and their progress.
+**2.** Retrieving Enrolled Students and Their Progress.
 
 
 {{{#!sql
-SELECT ue.first_name, ue.last_name, e.progress_percentage
+SELECT 
+    ue.first_name, ue.last_name,
+    e.enroll_date, e.progress_percentage, e.completion_status
 FROM enrollment e
-JOIN users u ON e.user_id = u.id
+JOIN users u ON u.id = e.user_id
 JOIN user_entity ue ON ue.id = u.id
-WHERE e.course_id = 1;
-
+WHERE e.course_id = :courseId;
 
 }}}