Changes between Version 2 and Version 3 of ViewingEnrolledStudents


Ignore:
Timestamp:
01/22/26 04:04:17 (15 hours ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ViewingEnrolledStudents

    v2 v3  
    55**1.** The instructor opens the Overview for a specific course.
    66
    7 **2.** The system generates a report with enrolled users and their progress.
     7**2.** Retrieving Enrolled Students and Their Progress.
    88
    99
    1010{{{#!sql
    11 SELECT ue.first_name, ue.last_name, e.progress_percentage
     11SELECT
     12    ue.first_name, ue.last_name,
     13    e.enroll_date, e.progress_percentage, e.completion_status
    1214FROM enrollment e
    13 JOIN users u ON e.user_id = u.id
     15JOIN users u ON u.id = e.user_id
    1416JOIN user_entity ue ON ue.id = u.id
    15 WHERE e.course_id = 1;
    16 
     17WHERE e.course_id = :courseId;
    1718
    1819}}}