Additional Language Search

[David Boyle]

This is a new feature.

Proposed feature is to add capability for additional search target languages to be specified.

Currently, Evergreen only allows the language specified in MARC 008 position 35-37 to be the target of a language search.
There is no current mechanism to allow for additional languages to be included as search targets.

The proposed change would add a new table (metabib.language_filter e.g.). This new table would contain a tsvector datatype. This tsvector would contain the languages associated with each bib record (tag 008 35-37 and selected 041 records).

Search code would be changed to join the metabib.language_filter table during the search query build.

The following perl module would be modified:

    ./Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm

Code would be added to include a join on the metabib:language_filter, so that the search languages would be included in the SQL search query.

A new table, metabib.language_filter, would be added to the schema. The columns of the table would be:

    id (primary key)
    source (foreign key to biblio.record_entry.id)
    value (tsvector containing 008 (35-37) and 041 subfield values containing languages associated with the selected bib record.

The language_filter table would be populated via a sql script, extracting 008 (35-37) and 041 subfields from the biblio.record_entry marc field.

A new trigger would be added:

    biblio.record_entry.language_filter_trigger

A new trigger procedure would be added for biblio.record_entry.language_filter_trigger:

    biblio.record_entry.update_language_filter

A new row would be added to config.org_unit_setting_type. This would allow the MARC 041 subfield(s) to be set via the Library Settings editor of Local Administration. The value in the org_unit_setting_type would be an array containing the specified subfield. For example, a value of "a,b,c" would specify that MARC 041 subfields a/b/c would be included as search language targets, as well as the default MARC 008/35-37 field.

Working Repository Branch: user/catalystit/additional_language_search

[Justin Douma (jdouma)]

Added Working Repository Branch: user/catalystit/additional_language_search

[Andrea Neiman (aneiman)]

Equinox was contracted to address this; however we took a different route. Our approach is detailed in bug 1733695. Marking this one as duplicate.