[OPEN-ILS-GENERAL] Apostrophe and Title Searches (still an issue?)

[Ian Bays]

We found that after upgrade from 2.1 to 2.2 the existing titles did not 
behave with apostrophes for title or keyword searching.  We observed 
that newly catalogued or edited titles did search OK with or without 
apostrophes.  So we investigated and found out that by just "touching" 
some of the metabib records that caused them to be re-indexed.

such as:
update metabib.title_field_entry set source = source where source in 
(select record from asset.call_number where owning_lib in (select id 
from actor.org_unit where parent_ou in (select id from actor.org_unit 
where shortname = 'AB' OR shortname = 'CD'))) and value like '%''%';
and
update metabib.keyword_field_entry set source = source where source in ...

We chose to only update those with apostrophes in the "value" field.  
This was to do it for bibs used in systems 'AB' and 'CD'

It did the job quite nicely.  I figured we must have missed something in 
the upgrade so just put it down to experience.

Not sure if there's a neater way of "touching" groups of records for 
re-indexing if ever needed.

Good luck.

Ian

On 20/11/2012 18:23, Tony Bandy wrote:
> Hi Dan, folks,
>
> So sorry...I should have been more detailed.
>
> Using TPAC on 2.3.1, and hostname http://mountgilead.cool-cat.org, 
> performing a title search for: Reader's Digest.  Under this method, I 
> get zero hits, even though "Reader's Digest" is returned in the 
> autocomplete box as I type the title.  If I perform the same search 
> without the apostrophe, I get good hits.
>
> Trying this same search on our training server with the same version 
> of Evergreen (2.3.1) I get the same response.
>
> -----------------
>
> To test, I've done the exact same search at King County Public Library 
> (http://catalog.kcls.org/eg/opac/home) and the demo server 
> (http://demo.ils.edoceo.com/sap/sunshine) and have not received the 
> error.  I also tried on the Equinox Demo server, but not sure if they 
> had the title as I got zero hits each time.
>
> -----------------
>
> Here's a sample of one of the MARC records that carry the title 
> Reader's Digest:
>
> 020 	
> 	. 	‡a0895773538
> 040 	
> 	. 	‡aDLC ‡cDLC ‡dDLC
> 050 	0 	0. 	‡aT47 ‡b.H725 1990
> 082 	0 	0. 	‡a600 ‡220
> 100 	1 	. 	‡aReader's Digest.
> 245 	0 	0. 	‡aHow in the World?
>
>
>
> Thanks for any updates as you have time....
>
>
> Tony
>
>
>
> On Tue, Nov 20, 2012 at 1:04 PM, Dan Scott <dan at coffeecode.net 
> <mailto:dan at coffeecode.net>> wrote:
>
>     On Tue, Nov 20, 2012 at 12:53:05PM -0500, Tony Bandy wrote:
>     > Hi all,
>     >
>     > After upgrading to 2.3, we're noticing the apostrophe issue when
>     doing
>     > title searching in the catalog.  Specifically, when using the
>     apostrophe,
>     > titles never get found.
>
>     Hi Tony:
>
>     Please provide more details.
>
>     What is the title in question? Where is the MARC record for it?
>
>     What search are you trying to use to retrieve the record? Are you
>     using
>     JSPAC or TPAC?
>
>     Can you reproduce the problem using a clean install of a supported
>     release?
>
>     Thanks,
>     Dan
>
>
>
>
> -- 
> Tony Bandy
> tonyb at ohionet.org <mailto:tonyb at ohionet.org>
> OHIONET
> 1500 West Lane Ave.
> Columbus, OH  43221-3975
> 614-486-2966 x19
>


-- 
Ian Bays
Director of Projects, PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 800 756 6803 (phone)
+44 (0) 7774 995297 (mobile)
+44 (0) 800 756 6384 (fax)
skype: ian.bays
email: ian.bays at ptfs-europe.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20121120/e8a5398e/attachment-0001.htm>