Module students_view 

Contains helper functions needed for student view

Structs

CertificateGridRow

CompletionGridRow

CourseStudentListRow

One row of the paginated student identity list (one row per distinct enrolled user).

CourseStudentsProgressStructure

Course-level progress structure for the Progress tab. Does not depend on which students are on the current page, so it is fetched once and cached per course (not per identity page).

CourseStudentsProgressUsers

Per-user progress detail for the Progress tab, scoped to the requested user_ids.

StudentsListPage

A page of the student identity list plus the total number of pages for the current filters.

Functions

escape_like_pattern 🔒

Escapes the LIKE/ILIKE metacharacters \, % and _ so a search string is matched literally (used together with ESCAPE '\' in the query).

get_certificates_grid_for_users

Returns the latest course certificate (if any) for each of the given users, keyed by user_id.

get_completions_grid_for_users

Returns student × module completion rows for the given users, keyed by user_id.

get_course_students_page

Returns a filtered, sorted, paginated page of the course’s enrolled users (identity only).

get_progress_for_users

Returns per-user chapter progress and locking statuses for the given user_ids.

get_progress_structure

Returns the course-level chapter structure shared by every page of the Progress tab.