@@ -, +, @@ Provided a smaller list based on reports/itemlost.tt --- C4/Items.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) --- a/C4/Items.pm +++ a/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) --