[OPEN-ILS-GENERAL] Inconsistent/wrong search results when searching by location in TPAC

[Sarah Childs]

We experience the same thing when we try to narrow a search to a 
particular shelving location. It generally just times out. I assume that 
approach works for single installations of Evergreen, and perhaps even 
small consortiums, but it's basically worthless for us.

---
Sarah Childs
Technical Services Department Head
Hussey-Mayfield Memorial Public Library
250 North Fifth Street
Zionsville, IN 46077
317-873-3149 x13330
sarahc at zionsville.lib.in.us

On 2014-01-21 20:55, Mike Rylander wrote:
> Justin,
> 
> The reason that search is slow is that you're effectively asking the
> system to return all bib records, then pull up all their copies, then
> pull up those copies' shelving locations, and finally filter out
> records that do not have copies that do not have shelving locations in
> your list.  That is exactly the reason I built the new items
> functionality.
> 
> With a little elbow grease, one could certainly use one of the many
> XML format output options available for use with the new items list to
> re-sort them however one would like, and display them exactly as one
> would wish.  Just try replacing "html-full" with "atom" or "rss2".
> 
> In fact, you could even use the OPAC to do the heavy lifting for you
> if you were to extract the record IDs from the XML new item feed and
> built a search using the record_list() filter and the sort(titlesort)
> operator.
> 
> Perhaps, with likely less total effort, an opac format could be added
> to the new item list, along with support for additional query
> components (such as sorting) in the case of the opac format.  A simple
> redirect would do.
> 
> A wishlist bug sounds like a good idea.  Perhaps time or funding will
> materialize.
> 
> 
> On Tue, Jan 21, 2014 at 6:21 PM, Holly Brennan 
> <haderhold at ci.homer.ak.us> wrote:
>> "This improves the presentation and allows for title sorting but the 
>> search
>> takes *forever* to return and the results are always way off and 
>> frequently
>> do not return any results at all. Having just tried it, TPAC claims 
>> there
>> are no results whatsoever. Two or three page refreshes later it turns 
>> up 353
>> items. According to the DB we have 1951 distinct bibs with items in 
>> those
>> locations.
>> 
>> 
>> 
>> Has anyone else seen this behavior? Is there an open bug on it? 
>> Should there
>> be?"
>> 
>> 
>> 
>> Weird. We, too, use "New Books" as a location for searching. I just 
>> pulled
>> up the whole batch of new adult books in our library (5,070 records) 
>> without
>> a problem. It took maybe one second to load the page.
>> 
>> 
>> 
>> I didn't find a delay using your search method, either.
>> 
>> 
>> 
>> I know this is sort of non-information, but it could be helpful so I 
>> chimed
>> in. Let us know if you solve the problem!
>> 
>> 
>> 
>> -Holly
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Holly Brennan
>> 
>> Library Technology Specialist
>> 
>> Homer Public Library
>> 
>> 907-235-3180 (main)
>> 
>> 907-435-3154 (direct)
>> 
>> hbrennan at cityofhomer-ak.gov
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> -----Original Message-----
>> From: open-ils-general-bounces at list.georgialibraries.org
>> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf 
>> Of
>> Justin Hopkins
>> Sent: Tuesday, January 21, 2014 12:56 PM
>> To: Evergreen Discussion Group
>> Subject: [OPEN-ILS-GENERAL] Inconsistent/wrong search results when 
>> searching
>> by location in TPAC
>> 
>> 
>> 
>> Hi guys,
>> 
>> 
>> 
>> Like probably many others, we have noticed that Evergreen is lacking 
>> a
>> really good "new books" feature. We've explored this:
>> 
>> 
>> 
>> http://missourievergreen.org/opac/extras/browse/html-full/item-age/SRLWA
>> 
>> 
>> 
>> The presentation of this option isn't very good though, and ideally 
>> we'd
>> have the ability to sort by title.
>> 
>> 
>> 
>> It just so happens that our library who is most interested in this 
>> has a
>> shelving location at each of their branches called New Books. So we 
>> tried
>> this approach using search syntax:
>> 
>> 
>> 
>> http://missourievergreen.org/eg/opac/results?fi:item_type=&query=locations(1307,1308,1309,1310,1311,1558,1559)+&qtype=keyword&locg=174&sort=titlesort)
>> 
>> 
>> 
>> This improves the presentation and allows for title sorting but the 
>> search
>> takes *forever* to return and the results are always way off and 
>> frequently
>> do not return any results at all. Having just tried it, TPAC claims 
>> there
>> are no results whatsoever. Two or three page refreshes later it turns 
>> up 353
>> items. According to the DB we have 1951 distinct bibs with items in 
>> those
>> locations.
>> 
>> 
>> 
>> Has anyone else seen this behavior? Is there an open bug on it? 
>> Should there
>> be?
>> 
>> Regards,
>> 
>> Justin
>> 
>> 
>> 
>> 
> 
> 
> 
> --
> 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