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 <d...@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 > > tspind...@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.*