Course list sorting is not optimal

[Jim Tittsler]

The list of courses should be sorted:

• Current (courses currently live: StartDate <= now <= EndDate, sorted by StartDate)
• Future (StartDate assigned, and now <= StartDate, sorted by StartDate)
• New (no StartDate assigned, sorted by IndictiveDate (sic))
• Past (EndDate < now, sorted by ?? (currently EndDate descending?)

I'm not sure of the value of displaying Past courses... but if they exist, they definitely should be pushed to the end of the list so that learners don't have to scroll past them.

[Jim Tittsler]

8f5c6209a50c changed the SQL query sort order so that courses are sorted:

• Future (specific start date has been scheduled)
• Current (both currently available self-paced courses and currently running scheduled courses)
• New (planned courses with approximate start)
• Past

This is not perfect because it somewhat disadvantages self-paced courses that are currently available.