Mercurial > hg > LightPIT / changeset

--- 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)