[OPEN-ILS-DEV] MFHD Display

Dan Scott dan at coffeecode.net
Fri Aug 24 10:00:55 EDT 2012


Heh, okay, it looks like there are 6 MFHD records attached to the bib
record for AIC (locg 152). Let's narrow it down with:

SELECT id, record, owning_lib
  FROM serial.record_entry
  WHERE record = 140858
    AND deleted IS FALSE
    AND marc LIKE '%Elms College%'
  ORDER BY owning_lib;



On Fri, Aug 24, 2012 at 09:49:25AM -0400, Tim Spindler wrote:
> Dan,
 
> 
> Tim
> 
> On Fri, Aug 24, 2012 at 9:35 AM, Dan Scott <dan at coffeecode.net> wrote:
> 
> > On Fri, Aug 24, 2012 at 09:23:49AM -0400, Tim Spindler wrote:
> > > I may have been confused about how this is designed to work but I was
> > > thinking the MFHD display would show only for owning library when the
> > > catalog is set to search that library only.  However, we are finding that
> > > all libraries holdings are displaying regardless of limit.  For instance,
> > > see
> > >
> > >
> > https://bark.cwmars.org/eg/opac/record/140858?query=title%3AAmerican%20Sociological%20Review;qtype=title;locg=152;_adv=1;page=0;expand=issues#issues
> > >
> > > If you look at issues held, it shows not only AIC's holdings but Elms
> > > College.
> > >
> > > I am also only referring the MFHD holdings statement and not the Serials
> > > holdings statemnt generate by batch receiving or receiving in the serials
> > > control view.
> >
> > You're right, it should only show the records for the indicated library
> > (or its children in the hierarchy).
> >
> > Can you show us the results of the SQL statement:
> >
> > "SELECT id, record, owning_lib FROM serial.record_entry WHERE record =
> > 140858;"
> >
> > Thanks,
> > Dan
> >
> 
> 
> 
> -- 
> 
> Tim Spindler
> 
> Manager of Library Applications
> 
> tspindler at cwmars.org
> 
> 508-755-3323 x20
> 
> 
> C/W MARS, Inc.
> 
> 67 Millbrook St, Suite 201
> 
> Worcester, MA 01606
> http://www.cwmars.org
> 
> 
> 
> *P**   Go Green - **Save a tree! Please don't print this e-mail unless it's
> really necessary.*


More information about the Open-ils-dev mailing list