[OPEN-ILS-DEV] MFHD Display

[Tim Spindler]

Dan,

This is the result.

idrecordowning_lib
1375
140858
190

I'll have to say I'm not sure what you are looking for with these queries
other than to possibly see if there is an Org_unit id mismatch.

Tim

On Fri, Aug 24, 2012 at 10:00 AM, Dan Scott <dan at coffeecode.net> wrote:

> 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.*
>



-- 

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.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20120824/6c663c30/attachment.htm>