From d88307264e94208d80e5c80d2d8e17f34dc3dcda Mon Sep 17 00:00:00 2001
From: "Meenakshi.R" <meenakshi.r@osslabs.biz>
Date: Wed, 23 May 2012 10:37:19 +0530
Subject: [PATCH] Bug 6655 - Sorting order of serial issues in OPAC

Works as advertised.

Signed-off-by: Elliott Davis <elliott@bywatersolutions.com>
Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
---
 C4/Serials.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 90335d03fc..98660e9e87 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -756,7 +756,7 @@ sub GetLatestSerials {
                         FROM     serial
                         WHERE    subscriptionid = ?
                         AND      (status =2 or status=4)
-                        ORDER BY planneddate DESC LIMIT 0,$limit
+                        ORDER BY publisheddate DESC LIMIT 0,$limit
                 ";
     my $sth = $dbh->prepare($strsth);
     $sth->execute($subscriptionid);
-- 
2.39.5