Sun, 01 Aug 2021 17:01:59 +0200
#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)