[almanah] Order search results by descending date



commit 49db044ccb5ca8f6658043915bf0e69e6a156e35
Author: Philip Withnall <philip tecnocode co uk>
Date:   Sun Apr 18 13:28:56 2010 +0100

    Order search results by descending date

 src/storage-manager.c |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/src/storage-manager.c b/src/storage-manager.c
index 5b4c4f7..c0b4659 100644
--- a/src/storage-manager.c
+++ b/src/storage-manager.c
@@ -879,7 +879,7 @@ almanah_storage_manager_search_entries (AlmanahStorageManager *self, const gchar
 
 	/* Prepare the statement */
 	if (sqlite3_prepare_v2 (self->priv->connection,
-				"SELECT content, day, month, year, is_important FROM entries", -1,
+				"SELECT content, day, month, year, is_important FROM entries ORDER BY year DESC, month DESC, day DESC", -1,
 				&statement, NULL) != SQLITE_OK) {
 		return -1;
 	}



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