Bugzilla – Attachment 11102 Details for
Bug 8329
GetLostItems in C4::Items.pm has a SELECT *
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8329 - GetLostItems in C4::Items.pm has a SELECT * Provided a smaller list based on reports/itemlost.tt
Bug-8329---GetLostItems-in-C4Itemspm-has-a-SELECT-.patch (text/plain), 1.04 KB, created by
Jonathan Druart
on 2012-07-24 10:36:40 UTC
(
hide
)
Description:
Bug 8329 - GetLostItems in C4::Items.pm has a SELECT * Provided a smaller list based on reports/itemlost.tt
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2012-07-24 10:36:40 UTC
Size:
1.04 KB
patch
obsolete
>From f5d60d8d324deb3590b7e37e48c1e0888dfec356 Mon Sep 17 00:00:00 2001 >From: Mark Tompsett <mtompset@hotmail.com> >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 <jonathan.druart@biblibre.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 8329
:
10565
| 11102