From 932b7365028fb13c013b2acac8ef4396b87f9c47 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Fri, 29 Jun 2012 22:40:24 +0800 Subject: [PATCH] Bug 8329 - GetLostItems in C4::Items.pm has a SELECT * Provided a smaller list based on reports/itemlost.tt Content-Type: text/plain; charset="utf-8" --- C4/Items.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/C4/Items.pm b/C4/Items.pm index 2afe537..0aa2ed9 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -908,7 +908,8 @@ sub GetLostItems { my $dbh = C4::Context->dbh; my $query = " - SELECT * + SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch, + itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber FROM items LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) -- 1.7.9.5