From f5d60d8d324deb3590b7e37e48c1e0888dfec356 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 Signed-off-by: Jonathan Druart --- C4/Items.pm | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) 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.7.3