[rygel/rygel-0-18] media-export: Fix sorting by date

[Jens Georg <jensgeorg src gnome org>]

commit 0380882e44dfbac57355620d216e94b31f855846
Author: Jens Georg <jensg openismus com>
Date:   Mon May 13 15:30:05 2013 +0200

    media-export: Fix sorting by date
    
    https://bugzilla.gnome.org/show_bug.cgi?id=694357

 .../rygel-media-export-media-cache.vala            |   12 +++++++++---
 1 files changed, 9 insertions(+), 3 deletions(-)
---
diff --git a/src/plugins/media-export/rygel-media-export-media-cache.vala 
b/src/plugins/media-export/rygel-media-export-media-cache.vala
index 3267a01..907f6f0 100644
--- a/src/plugins/media-export/rygel-media-export-media-cache.vala
+++ b/src/plugins/media-export/rygel-media-export-media-cache.vala
@@ -928,7 +928,8 @@ public class Rygel.MediaExport.MediaCache : Object {
     }
 
     private static string? map_operand_to_column (string     operand,
-                                                  out string? collate = null)
+                                                  out string? collate = null,
+                                                  bool        for_sort = false)
                                                   throws Error {
         string column = null;
         bool use_collation = false;
@@ -962,7 +963,11 @@ public class Rygel.MediaExport.MediaCache : Object {
                 use_collation = true;
                 break;
             case "dc:date":
-                column = "strftime(\"%Y\", m.date)";
+                if (for_sort) {
+                    column = "m.date";
+                } else {
+                    column = "strftime(\"%Y\", m.date)";
+                }
                 break;
             case "upnp:album":
                 column = "m.album";
@@ -1089,7 +1094,8 @@ public class Rygel.MediaExport.MediaCache : Object {
             try {
                 var column = MediaCache.map_operand_to_column
                                         (field[1:field.length],
-                                         out collate);
+                                         out collate,
+                                         true);
                 if (field != fields[0]) {
                     builder.append (",");
                 }