From d8f0e7b79e78c4533bb82bc18bff8450ea815042 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 10 Jul 2015 15:18:48 +0100 Subject: [PATCH] [PASSED QA] Bug 8723: Update hold_fill_targets, tmp_holdsqueue and linktracker tables Same as previous patch for 3 other tables. Test plan: Same as before but the hold should exist to the 3 tables before the move. Signed-off-by: Nick Clemens Signed-off-by: Katrin Fischer --- C4/Items.pm | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index 3ce710c..0194787 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -2278,13 +2278,14 @@ sub MoveItemFromBiblio { C4::Acquisition::ModOrder($order); } - # Update holds - $dbh->do( q| - UPDATE reserves - SET biblionumber = ? - WHERE itemnumber = ? - |, undef, $tobiblio, $itemnumber ); - + # Update reserves, hold_fill_targets, tmp_holdsqueue and linktracker tables + for my $table_name ( qw( reserves hold_fill_targets tmp_holdsqueue linktracker ) ) { + $dbh->do( qq| + UPDATE $table_name + SET biblionumber = ? + WHERE itemnumber = ? + |, undef, $tobiblio, $itemnumber ); + } return $tobiblio; } return; -- 1.9.1