When sorting a “User Course Transcripts“ report in HR Learn with multiple ascending and descending filters, the unique enrollment ID in the course title field needs to be factored into your sorting logic.
As you will see in reporting data, the course title field will always include a unique enrollment ID per each user's course enrollment:
This unique enrollment ID could throw off your set ascending and descending orders depending on what you are selecting.
For example, if your report contains more than one course, and you want to sort by course title so that all courses are grouped together in ascending order and then sort by the date completed for those course enrollments in ascending order, the unique enrollment ID may alter your report display.
Since the unique enrollment IDs are included in course field values, sorting by course would ultimately sort same-course enrollments by enrollment ID.
Here are two workarounds if you run into this problem:
-
Sort results by code instead of course. However, this workaround can’t be applied to enrollments for courses without a course code.
-
Retrieve results for one course at a time. That is, set a “Course contains XYZ” filter and sort by Date Completed only.