Bugzilla – Attachment 11635 Details for
Bug 8648
searchResults uses SQL query rather than GetMarcFromKohaField
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 8648: searchResults uses SQL query rather than GetMarcFromKohaField
0001-Bug-8648-searchResults-uses-SQL-query-rather-than-Ge.patch (text/plain), 1.35 KB, created by
Julian Maurice
on 2012-08-16 09:48:24 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 8648: searchResults uses SQL query rather than GetMarcFromKohaField
Filename:
MIME Type:
Creator:
Julian Maurice
Created:
2012-08-16 09:48:24 UTC
Size:
1.35 KB
patch
obsolete
>From a3b5fb2b9f44526b472833cb2e87d16903497b4d Mon Sep 17 00:00:00 2001 >From: Jared Camins-Esakov <jcamins@cpbibliography.com> >Date: Wed, 15 Aug 2012 15:48:05 -0400 >Subject: [PATCH] Bug 8648: searchResults uses SQL query rather than > GetMarcFromKohaField > >Around line 1470-something: > > my $sth = > $dbh->prepare( > "SELECT tagfield FROM marc_subfield_structure WHERE kohafield LIKE > 'items.itemnumber'" > ); > $sth->execute; > >This patch replaces that with a call to GetMarcFromKohaField. > >To test: >1) Apply patch. >2) Do a search that returns both available and unavailable items. > You'll know if the patch isn't working. > >Signed-off-by: Julian Maurice <julian.maurice@biblibre.com> >--- > C4/Search.pm | 7 +------ > 1 file changed, 1 insertion(+), 6 deletions(-) > >diff --git a/C4/Search.pm b/C4/Search.pm >index fd81610..0c7e151 100644 >--- a/C4/Search.pm >+++ b/C4/Search.pm >@@ -1469,12 +1469,7 @@ sub searchResults { > } > > #search item field code >- my $sth = >- $dbh->prepare( >-"SELECT tagfield FROM marc_subfield_structure WHERE kohafield LIKE 'items.itemnumber'" >- ); >- $sth->execute; >- my ($itemtag) = $sth->fetchrow; >+ my ($itemtag, undef) = &GetMarcFromKohaField( "items.itemnumber", "" ); > > ## find column names of items related to MARC > my $sth2 = $dbh->prepare("SHOW COLUMNS FROM items"); >-- >1.7.10.4 >
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 8648
:
11629
| 11635