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