Hi Holly, I'm not certain this is something that can be done via the staff client's reports, but this is my thinking so far...
Because most given holds are title holds and targeting bib records, but all copy locations are tied to items, it's not always going to be a one for one connection from hold to specific item that I can think of. An approach I might use in this situation would be getting a list of the bib records associated with a given set of items belonging to a particular copy location and then seeing which holds target those bib records. The following is something I whipped up quickly in SQL that might work: -- Title of material, # of holds -- Number of title holds targeted towards bib records with copies associated with a copy location named 'In Process' SELECT rmsr.title, COUNT(*) FROM action.hold_request ahr JOIN reporter.materialized_simple_record rmsr ON rmsr.id = ahr.target WHERE ahr.hold_type = 'T' AND ahr.target IN ( SELECT acn.record FROM asset.copy ac JOIN asset.copy_location acl ON acl.id = ac.location JOIN asset.call_number acn ON acn.id = ac.call_number WHERE acl.name = 'In Process' AND ac.deleted = FALSE) GROUP BY 1 ORDER BY 2 DESC; Some potential caveats include figuring whether or not to count inactive/suspended holds or adding some union merges to count also things like volume or copy holds (among other types of holds) as well if we were to focus on all the various ways holds could be placed trying to get these items. Good luck, curious to see what other folks think of for this question. -- Ben On Wed, Oct 30, 2013 at 6:55 PM, Holly Brennan <[email protected]> wrote: > This is part of the question I sent out earlier, but since I received an > answer to the complicated part I figured I’d try again with a > smaller/simpler email. (So please excuse the double posting) > > > > Is there a way to find items that have holds placed on them, based on > location? The best process would be a report that can pull “items on hold” > and “location = In Process” that we can run every few days. It does not need > to be fancy and integrated like the standard Pull List. > > > > We’re still on 2.3.4, so maybe this is an option on 2.4 or 2.5? I haven’t > had any luck searching chat/wiki/Launchpad/release notes. > > > > If you don’t know, but are interested in this option, speak up! I can start > a Launchpad campaign if it’s not in the works already. > > > > Thanks! > > > > - Holly > > > > > > > > > > Holly Brennan > > Library Technician II > > Cataloging & Tech Services > > Homer Public Library > > 907-235-3180 (main) > > 907-435-3154 (direct) > > [email protected] > >
