#152 same sort order for versions and version summaries

Sun, 01 Aug 2021 17:01:59 +0200

author
Mike Becker <universe@uap-core.de>
date
Sun, 01 Aug 2021 17:01:59 +0200
changeset 203
7d5b16379768
parent 202
bbfc46ed3520
child 204
54c612612c69

#152 same sort order for versions and version summaries

src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt file | annotate | diff | comparison | revisions
--- 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)

mercurial