#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
     1.1 --- a/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sun Aug 01 16:59:49 2021 +0200
     1.2 +++ b/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sun Aug 01 17:01:59 2021 +0200
     1.3 @@ -182,7 +182,7 @@
     1.4              left join summary aa on aa.versionid = v.versionid and aa.phase = 1 and not aa.isresolved
     1.5              left join summary ad on ad.versionid = v.versionid and ad.phase = 2 and not ad.isresolved
     1.6              where v.project = ?
     1.7 -            order by ordinal, name
     1.8 +            order by ordinal desc, lower(name) desc
     1.9              """.trimIndent()
    1.10          ) {
    1.11              setInt(1, project.id)

mercurial