+1 to removing it entirely.

On Thu, Dec 11, 2014 at 12:59 PM, Rogan Hamby <email address hidden> wrote:

> I am in favor of removing it entirely.
>
> On Thu, Dec 11, 2014 at 12:48 PM, Kathy Lussier <
> <email address hidden>>
> wrote:
> >
> > Given that most sites have indicated they do not use this search option,
> > my preference is to remove it entirely. I think it causes confusion for
> > users for sites that do not know how to remove it and also causes
> > confusion for new libraries moving to Evergreen.
> >
> > --
> > You received this bug notification because you are subscribed to
> > Evergreen.
> > Matching subscriptions: evergreenbugs
> > https://bugs.launchpad.net/bugs/1074096
> >
> > Title:
> >   Advanced Search by Bib Call Number Returns 0 Results
> >
> > Status in Evergreen - Open ILS:
> >   Triaged
> >
> > Bug description:
> >   Evergreen 2.2.2
> >   Postgres 9.1
> >   Debian Squeeze
> >
> >   When attempting to query by Advanced Search -> Numeric Search with a
> >   selection of Bib Call Number an error is encounted as follows:
> >
> >
> >   Caught error from 'run' method: Exception: OpenSRF::EX::ERROR
> > 2012-11-01T10:22:44 OpenSRF::Application
> > /usr/local/share/perl/5.10.1/OpenSRF/Application.pm:209 System ERROR:
> Call
> > to open-ils.storage for method
> > open-ils.storage.biblio.multiclass.staged.search_fts.staff.atomic
> >    failed with exception: Exception: OpenSRF::EX::ERROR
> > 2012-11-01T10:22:44 OpenILS::Application::AppUtils
> > /usr/local/share/perl/5.10.1/OpenILS/Application/AppUtils.pm:186 System
> > ERROR: Exception: OpenSRF::DomainObject::oilsMethodException
> > 2012-11-01T10:22:44 OpenSRF::AppRequest
> > /usr/local/share/perl/5.10.1/OpenSRF/AppSession.pm:1064 <500>   *** Call
> to
> > [open-ils.storage.biblio.multiclass.staged.search_fts.staff.atomic]
> failed
> > for session [1351779763.88325974.147008885412], thread trace [1]:
> >   DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"
> >   LINE 21:    WHERE fe_weight.id IN  ()
> >                                       ^
> >   QUERY:  SELECT  m.source AS id,
> >           ARRAY_ACCUM(DISTINCT m.source) AS records,
> >           1.0/(AVG(
> >           (COALESCE(ts_rank_cd(xacd12f0_identifier_bib_cn.index_vector,
> > xacd12f0_identifier_bib_cn.tsq, 14) * xacd12f0_identifier_bib_cn.weight,
> > 0.0))
> >       )+1)::NUMERIC AS rel,
> >           1.0/(AVG(
> >           (COALESCE(ts_rank_cd(xacd12f0_identifier_bib_cn.index_vector,
> > xacd12f0_identifier_bib_cn.tsq, 14) * xacd12f0_identifier_bib_cn.weight,
> > 0.0))
> >       )+1)::NUMERIC AS rank,
> >           FIRST(mrd.attrs->'date1') AS tie_break
> >     FROM  metabib.metarecord_source_map m
> >           JOIN metabib.record_attr mrd ON (m.source = mrd.id)
> >
> >
> >       LEFT JOIN (
> >           SELECT fe.*, fe_weight.weight, x.tsq /* search */
> >             FROM  metabib.identifier_field_entry AS fe
> >               JOIN config.metabib_field AS fe_weight ON (fe_weight.id =
> > fe.field)
> >               JOIN (SELECT
> >               to_tsquery('identifier', COALESCE(NULLIF( '(' ||
> >
> btrim(regexp_replace($_32475$PN1997.G59$_32475$,E'(?:\\s+|:)','&','g'),'&|')
> > || ')', '()'), '')) AS tsq ) AS x ON (fe.index_vector @@ x.tsq)
> >               WHERE fe_weight.id IN  ()
> >       ) AS xacd12f0_identifier_bib_cn ON (m.source =
> > xacd12f0_identifier_bib_cn.source)
> >     WHERE 1=1
> >
> >   Discussion in chat indicated there may be something missing from a
> >   configuration table but we are not able to determine the setting(s)
> >   required to make this query perform as in 2.1 release.
> >
> >   In 2.1 the query would return results based on  records that contain
> >   the call number string entered in one of the MARC call number fields.
> >   (082, 050 or 092 for example)
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/evergreen/+bug/1074096/+subscriptions
> >
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1074096
>
> Title:
>   Advanced Search by Bib Call Number Returns 0 Results
>
> Status in Evergreen - Open ILS:
>   Triaged
>
> Bug description:
>   Evergreen 2.2.2
>   Postgres 9.1
>   Debian Squeeze
>
>   When attempting to query by Advanced Search -> Numeric Search with a
>   selection of Bib Call Number an error is encounted as follows:
>
>
>   Caught error from 'run' method: Exception: OpenSRF::EX::ERROR
> 2012-11-01T10:22:44 OpenSRF::Application
> /usr/local/share/perl/5.10.1/OpenSRF/Application.pm:209 System ERROR: Call
> to open-ils.storage for method
> open-ils.storage.biblio.multiclass.staged.search_fts.staff.atomic
>    failed with exception: Exception: OpenSRF::EX::ERROR
> 2012-11-01T10:22:44 OpenILS::Application::AppUtils
> /usr/local/share/perl/5.10.1/OpenILS/Application/AppUtils.pm:186 System
> ERROR: Exception: OpenSRF::DomainObject::oilsMethodException
> 2012-11-01T10:22:44 OpenSRF::AppRequest
> /usr/local/share/perl/5.10.1/OpenSRF/AppSession.pm:1064 <500>   *** Call to
> [open-ils.storage.biblio.multiclass.staged.search_fts.staff.atomic] failed
> for session [1351779763.88325974.147008885412], thread trace [1]:
>   DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"
>   LINE 21:    WHERE fe_weight.id IN  ()
>                                       ^
>   QUERY:  SELECT  m.source AS id,
>           ARRAY_ACCUM(DISTINCT m.source) AS records,
>           1.0/(AVG(
>           (COALESCE(ts_rank_cd(xacd12f0_identifier_bib_cn.index_vector,
> xacd12f0_identifier_bib_cn.tsq, 14) * xacd12f0_identifier_bib_cn.weight,
> 0.0))
>       )+1)::NUMERIC AS rel,
>           1.0/(AVG(
>           (COALESCE(ts_rank_cd(xacd12f0_identifier_bib_cn.index_vector,
> xacd12f0_identifier_bib_cn.tsq, 14) * xacd12f0_identifier_bib_cn.weight,
> 0.0))
>       )+1)::NUMERIC AS rank,
>           FIRST(mrd.attrs->'date1') AS tie_break
>     FROM  metabib.metarecord_source_map m
>           JOIN metabib.record_attr mrd ON (m.source = mrd.id)
>
>
>       LEFT JOIN (
>           SELECT fe.*, fe_weight.weight, x.tsq /* search */
>             FROM  metabib.identifier_field_entry AS fe
>               JOIN config.metabib_field AS fe_weight ON (fe_weight.id =
> fe.field)
>               JOIN (SELECT
>               to_tsquery('identifier', COALESCE(NULLIF( '(' ||
> btrim(regexp_replace($_32475$PN1997.G59$_32475$,E'(?:\\s+|:)','&','g'),'&|')
> || ')', '()'), '')) AS tsq ) AS x ON (fe.index_vector @@ x.tsq)
>               WHERE fe_weight.id IN  ()
>       ) AS xacd12f0_identifier_bib_cn ON (m.source =
> xacd12f0_identifier_bib_cn.source)
>     WHERE 1=1
>
>   Discussion in chat indicated there may be something missing from a
>   configuration table but we are not able to determine the setting(s)
>   required to make this query perform as in 2.1 release.
>
>   In 2.1 the query would return results based on  records that contain
>   the call number string entered in one of the MARC call number fields.
>   (082, 050 or 092 for example)
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/evergreen/+bug/1074096/+subscriptions
>



-- 
Sarah Childs
Technical Services Department Head
Hussey-Mayfield Memorial Public Library
250 North Fifth Street
Zionsville, IN 46077
317-873-3149 x13330
<email address hidden>