[OPEN-ILS-GENERAL] Series indexing and facet implications

[Elizabeth Longwell]

Mike,

Possible series entries come from 440$a$v as well as 800$t$v (paired
with 490 entry). Is possible to feed index from two different marc
tags within same definition?

Beth

On Thu, Feb 2, 2012 at 7:00 AM, Mike Rylander <mrylander at gmail.com> wrote:
> On Thu, Feb 2, 2012 at 9:39 AM, Elizabeth Longwell <blongwel at eou.edu> wrote:
>> Fellow Evergreeners,
>>
>> Series facets are showing the entire series entry (title and volume),
>> which is not as useful for patrons who would like to limit their
>> search to a particular series rather than a specific volume of the
>> series. I thought I could use the facet xpath to narrow it down to the
>> series title only, but discovered that the series is being indexed
>> using the mods32 related item/type-series/titleinfo which does not
>> break apart the title and volume info. I'm wondering if anyone has
>> corrected this in their system and has any advice. I'm trying to
>> decide whether to change the current indexing or just create a second
>> index that targets a specific marc tag/subfield combo to grab the
>> series title only.
>>
>> I would be grateful for any advice/help. Thanks,
>>
>
> If you're only using 440$a$v for series info in your MARC, you could
> do something along the lines of:
>
> BEGIN;
> UPDATE config.metabib_field
>  SET xpath = '//*[@tag="440"]', format = 'marcxml', facet_xpath =
> '//*[@code="a"]'
>  WHERE id = 1;
> UPDATE metabib.facet_entry SET value = regexp_replace(value,
> $$\s*;.*$$, '') WHERE field = 1;
> COMMIT;
>
> That's all untested, and mainly from memory, so, no warranty expressed
> or implied!
>
> --
> Mike Rylander
>  | Director of Research and Development
>  | Equinox Software, Inc. / Your Library's Guide to Open Source
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  miker at esilibrary.com
>  | web:  http://www.esilibrary.com