From f001daa8f4bc6bbcb471da6216d8c71e06fc9b6d Mon Sep 17 00:00:00 2001 From: Ian Walls Date: Sat, 27 Aug 2011 20:25:20 -0400 Subject: [PATCH] Bug 3521: items table in catalogue/detail.pl sorted nonsensically Items were sorted by branch, then date accessioned, in GetItemsInfo. While this can be helpful in some circumstances, more often it is useful for items to be sorted first by their enumchron (volume/issue, if applicable) then by their copy number. This patch changes the sort on GetItemsInfo to branch, enumcrhon, copynumber then date accessioned. --- C4/Items.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index bc36dd1..e8e00af 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -1181,7 +1181,7 @@ sub GetItemsInfo { LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber LEFT JOIN itemtypes ON itemtypes.itemtype = " . (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype'); - $query .= " WHERE items.biblionumber = ? ORDER BY branches.branchname,items.dateaccessioned desc" ; + $query .= " WHERE items.biblionumber = ? ORDER BY branches.branchname,items.enumchron,items.copynumber,items.dateaccessioned desc" ; my $sth = $dbh->prepare($query); $sth->execute($biblionumber); my $i = 0; -- 1.7.4.1