diff options
| author | Jan-Hendrik Willms <tleilax+studip@gmail.com> | 2025-07-01 12:56:01 +0200 |
|---|---|---|
| committer | Jan-Hendrik Willms <tleilax+studip@gmail.com> | 2025-07-01 12:56:01 +0200 |
| commit | 054248f3b95fa24ace3c3e7b599858401f6dce5d (patch) | |
| tree | e0280549aa67c6141c874384af31f0729b39a0bc /lib/classes/globalsearch | |
| parent | b06634ab30ecc95a0c03640c3cd588f04e6a1288 (diff) | |
Apply 1 suggestion(s) to 1 file(s)biest-1347
Diffstat (limited to 'lib/classes/globalsearch')
| -rw-r--r-- | lib/classes/globalsearch/GlobalSearchCourses.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/classes/globalsearch/GlobalSearchCourses.php b/lib/classes/globalsearch/GlobalSearchCourses.php index ce82199..210aa0d 100644 --- a/lib/classes/globalsearch/GlobalSearchCourses.php +++ b/lib/classes/globalsearch/GlobalSearchCourses.php @@ -123,7 +123,8 @@ class GlobalSearchCourses extends GlobalSearchModule implements GlobalSearchFull GROUP BY courses.Seminar_id"; if (Config::get()->IMPORTANT_SEMNUMBER) { - $sql .= " ORDER BY CASE WHEN courses.`VeranstaltungsNummer` THEN courses.`VeranstaltungsNummer` ELSE MAX(`semester_data`.`beginn`) END"; + $sql .= " ORDER BY courses.`VeranstaltungsNummer` = '', courses.`VeranstaltungsNummer`, MAX(`semester_data`.`beginn`) DESC"; + } else { $sql .= " ORDER BY MAX(`semester_data`.`beginn`) DESC"; } |
