From 5b4752e027ce32492166c7018d44d4a687afae36 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 19 Mar 2013 14:41:52 +0100 Subject: [PATCH] Bug 8365: FIX Return issue values instead of item values Before this patch, the GetItemIssue routine returns items.renewals instead of issues.renewals Signed-off-by: Broust Signed-off-by: Katrin Fischer All tests and QA script pass. Signed-off-by: Jared Camins-Esakov --- C4/Circulation.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 08935e207b..f3c5808af2 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -2255,7 +2255,7 @@ sub GetItemIssue { my ($itemnumber) = @_; return unless $itemnumber; my $sth = C4::Context->dbh->prepare( - "SELECT * + "SELECT items.*, issues.* FROM issues LEFT JOIN items ON issues.itemnumber=items.itemnumber WHERE issues.itemnumber=?"); -- 2.39.2