From 9d5891a60b46bc5666974c521d2cb0f7c003b42f Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Tue, 22 Jan 2013 16:18:05 +0100 Subject: o Fixing so that it queries builds based on created_date and not timestamp. --- src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/main/java') diff --git a/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java b/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java index d21118d..46fdc29 100755 --- a/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java +++ b/src/main/java/io/trygvis/esper/testing/jenkins/JenkinsDao.java @@ -174,7 +174,7 @@ public class JenkinsDao { public List selectBuildByJob(UUID job, PageRequest page) throws SQLException { String sql = "SELECT " + JENKINS_BUILD + " FROM jenkins_build WHERE job=?"; - sql += orderBy(ifEmpty(page.orderBy, "created_date-"), "created_date", "timestamp"); + sql += orderBy(ifEmpty(page.orderBy, "created_date-"), "created_date"); sql += " LIMIT ? OFFSET ?"; try (PreparedStatement s = c.prepareStatement(sql)) { -- cgit v1.2.3