# HG changeset patch
# User Mike Becker <universe@uap-core.de>
# Date 1627830119 -7200
# Node ID 7d5b163797687d5d27a86490c6f4ad754065b0c7
# Parent  bbfc46ed352093e0c39874d0ff6c18ded86928e9
#152 same sort order for versions and version summaries

diff -r bbfc46ed3520 -r 7d5b16379768 src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
--- a/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sun Aug 01 16:59:49 2021 +0200
+++ b/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sun Aug 01 17:01:59 2021 +0200
@@ -182,7 +182,7 @@
             left join summary aa on aa.versionid = v.versionid and aa.phase = 1 and not aa.isresolved
             left join summary ad on ad.versionid = v.versionid and ad.phase = 2 and not ad.isresolved
             where v.project = ?
-            order by ordinal, name
+            order by ordinal desc, lower(name) desc
             """.trimIndent()
         ) {
             setInt(1, project.id)