[Koha-patches] [PATCH] bug: query squashes issues.timestamp which circulation.pl needs to sort todaysissues

[Michael Hafen]

Little change to the query so we get the right timestamp to sort on.
---
 C4/Members.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index 6c66dd9..8a30ca6 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -998,7 +998,7 @@ sub GetPendingIssues {
     my $dbh              = C4::Context->dbh;
 
     my $sth              = $dbh->prepare(
-   "SELECT * FROM issues 
+   "SELECT *,issues.timestamp as timestamp FROM issues 
       LEFT JOIN items ON issues.itemnumber=items.itemnumber
       LEFT JOIN biblio ON     items.biblionumber=biblio.biblionumber 
       LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber
-- 
1.5.4.3