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

[Mike Rylander]

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