[almanah] Order search results by descending date
- From: Philip Withnall <pwithnall src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [almanah] Order search results by descending date
- Date: Sun, 18 Apr 2010 13:26:55 +0000 (UTC)
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]