From c2a5677a46f91696ec7748d7d1202fe5d5f685f7 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Sat, 12 Jan 2013 14:19:19 +0100 Subject: o Sorting the badge list with newest first. --- src/main/java/io/trygvis/esper/testing/core/db/PersonDao.java | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/main/java/io/trygvis/esper/testing/core/db/PersonDao.java') diff --git a/src/main/java/io/trygvis/esper/testing/core/db/PersonDao.java b/src/main/java/io/trygvis/esper/testing/core/db/PersonDao.java index 58af119..8d74264 100755 --- a/src/main/java/io/trygvis/esper/testing/core/db/PersonDao.java +++ b/src/main/java/io/trygvis/esper/testing/core/db/PersonDao.java @@ -198,7 +198,8 @@ public class PersonDao { sql += " AND level=?"; } - sql += " ORDER BY created_date DESC"; + sql += orderBy(page.orderBy, "name", "created_date"); + sql += " LIMIT ? OFFSET ?"; try (PreparedStatement s = c.prepareStatement(sql)) { -- cgit v1.2.3