holdingbranch table not referenced in view_holdsqueue.pl, causing irresolvable
ambiguity in
sql query when limited by library (holdingbranch). This was causing DBI errors
to be thrown
in test database, and library-limited holdsqueue display was thus empty.
---
circ/view_holdsqueue.pl | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/circ/view_holdsqueue.pl b/circ/view_holdsqueue.pl
index a52400b..e8e47a6 100755
--- a/circ/view_holdsqueue.pl
+++ b/circ/view_holdsqueue.pl
@@ -101,7 +101,7 @@ sub GetHoldsQueueItems {
LEFT JOIN items USING (itemnumber)
/;
if ($branchlimit) {
- $query .=" WHERE holdingbranch = ?";
+ $query .=" WHERE tmp_holdsqueue.holdingbranch = ?";
push @bind_params, $branchlimit;
}
$query .= " ORDER BY ccode, location, cn_sort, author, title, pickbranch,
reservedate";
--
1.5.5.GIT
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
