From 885c68e269419813dafde37fbeb32052e16974a1 Mon Sep 17 00:00:00 2001 From: Jane Wagner Date: Thu, 21 Jan 2010 15:33:23 -0500 Subject: [PATCH] Bug 3294 Use cn_sort field to sort inventory list output The inventory tool was using itemcallnumber, title to sort; modified Items.pm to use cn_sort, itemcallnumber, title so that call numbers sorted on the padded sort field instead. --- C4/Items.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Items.pm b/C4/Items.pm index ccf8b0563b..3a4ec9173c 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -1079,7 +1079,7 @@ END_SQL $query .= 'WHERE '; $query .= join ' AND ', @where_strings; } - $query .= ' ORDER BY itemcallnumber, title'; + $query .= ' ORDER BY items.cn_sort, itemcallnumber, title'; my $sth = $dbh->prepare($query); $sth->execute( @bind_params ); -- 2.39.5