Mercurial > hg > LightPIT / file diff

--- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java	Fri Oct 09 11:57:05 2020 +0200
+++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java	Fri Oct 09 15:35:48 2020 +0200
@@ -56,8 +56,7 @@
                         "from lpit_issue i " +
                         "join lpit_project p on project = projectid " +
                         "left join lpit_user on userid = assignee " +
-                        "where project = ? "+
-                        "order by eta asc, updated desc");
+                        "where project = ? ");
 
         listForVersion = connection.prepareStatement(
                 "with issue_version as ( "+
@@ -70,8 +69,7 @@
                         "join lpit_project p on project = projectid " +
                         "left join issue_version using (issueid) "+
                         "left join lpit_user on userid = assignee " +
-                        "where coalesce(versionid,-1) = ? "+
-                        "order by eta asc, updated desc"
+                        "where coalesce(versionid,-1) = ? "
         );
 
         find = connection.prepareStatement(