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
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
