[hamster-applet] typo in query - should order by the time of the most recent entry, instead of the time of the first



commit 2ea58c6a2202db5b3cad18cd41fe4d4e0c32ac7c
Author: Toms Bauģis <toms baugis gmail com>
Date:   Wed Jan 20 11:57:52 2010 +0000

    typo in query - should order by the time of the most recent entry, instead of the time of the first entry with this activity

 hamster/db.py |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/hamster/db.py b/hamster/db.py
index b0c7ade..f2eb481 100644
--- a/hamster/db.py
+++ b/hamster/db.py
@@ -764,7 +764,7 @@ class Storage(storage.Storage):
                     WHERE deleted IS NULL
                       AND a.name LIKE ? ESCAPE '\\'
                  GROUP BY a.id
-                 ORDER BY min(f.start_time) DESC, lower(a.name)
+                 ORDER BY max(f.start_time) DESC, lower(a.name)
                     LIMIT 50
         """
         search = search.replace('\\', '\\\\').replace('%', '\\%').replace('_', '\\_')



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]