From 00437c6bf232783ea1c04cafe8e5bcae8e143aa6 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 Signed-off-by: Paul Poulain --- C4/Items.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/C4/Items.pm b/C4/Items.pm index a9c0a16084..e9af3dd67d 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -936,7 +936,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) -- 2.39.5