1.1 --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Fri Oct 09 11:57:05 2020 +0200
1.2 +++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java Fri Oct 09 15:35:48 2020 +0200
1.3 @@ -56,8 +56,7 @@
1.4 "from lpit_issue i " +
1.5 "join lpit_project p on project = projectid " +
1.6 "left join lpit_user on userid = assignee " +
1.7 - "where project = ? "+
1.8 - "order by eta asc, updated desc");
1.9 + "where project = ? ");
1.10
1.11 listForVersion = connection.prepareStatement(
1.12 "with issue_version as ( "+
1.13 @@ -70,8 +69,7 @@
1.14 "join lpit_project p on project = projectid " +
1.15 "left join issue_version using (issueid) "+
1.16 "left join lpit_user on userid = assignee " +
1.17 - "where coalesce(versionid,-1) = ? "+
1.18 - "order by eta asc, updated desc"
1.19 + "where coalesce(versionid,-1) = ? "
1.20 );
1.21
1.22 find = connection.prepareStatement(
