I've been looking into how to handle OCLC last copies for our consortium this
week and I just wanted to run in by the group. Please let me know if there is
a better/easier way to handle this that you have found. Or if there are any
gotchas that you know of.
I searched the general list to find out what others are doing and didn't see
that there was a great built in way to do it with the reporter. So I attempted
to do it with a sql query.
There is a "Last Copy Delete Time" data source that that doesn't seem to take
the copy location into account, it works off of the bib being deleted.
I'm wondering if this could be setup as a reporter data source to make it
easier to access. After looking at the "Hold per copy ratio by pickup and
descendants" data source that Galen just added it looks like it should be
possible.
The query selects all bib records that have one or more copies with a
discard/weed status and gives a count of the number of copies that have that
status, along with a count of all other copies on that bib that have a status
other than weed/discard. If there are no other copies then you have removed
the last copy. It scopes the search to an org unit and all of its descendants,
so it can be used for one branch, or for a system.
This method does require that you change the status of all copies you want to
get rid of to withdrawn/weed before deleting them. So your workflow for
getting rid of lost/damaged/missing/long overdue may need to be adjusted. Or
the query could look for more status types to consider deleted and not deleted.
I'm not sure what the best way to handle that would be.
I also wasn't sure about the subqueries, if I needed to use different table
aliases than what is used in the main query, so that may be unnecessary.
In the following query you would need to change the org unit id "101" in the
actor.org_unit_descendants to your org unit you want to scope to. And I don't
know if the asset.copy.status id numbers are uniform, so check to make sure
that 13 = your withdrawn/weed status.
SELECT bre.id,
bre.tcn_value,
Xpath('n:datafield[@tag=035]/n:subfield[@code="a"]/text()',
bre.marc :: xml, '{{n,http://www.loc.gov/MARC21/slim}}'),
Count(ac.id) AS
withdrawn_count,
(SELECT Count(ac1.id)
FROM asset.copy ac1
JOIN asset.call_number acn1
ON ( ac1.call_number = acn1.id )
WHERE acn1.record = bre.id
AND ac1.status != 13
AND ac1.circ_lib IN (SELECT id
FROM actor.org_unit_descendants(101))) AS
other_copies
FROM biblio.record_entry bre
JOIN asset.call_number acn
ON ( bre.id = acn.record )
JOIN asset.copy ac
ON ( acn.id = ac.call_number )
WHERE ac.status = 13
AND ac.circ_lib IN (SELECT id
FROM actor.org_unit_descendants(101))
AND (SELECT Count(ac1.id)
FROM asset.copy ac1
JOIN asset.call_number acn1
ON ( ac1.call_number = acn1.id )
WHERE acn1.record = bre.id
AND ac1.status != 13
AND ac1.circ_lib IN (SELECT id
FROM
actor.org_unit_descendants(101))) = 0
GROUP BY bre.id;
Josh Stompro - LARL IT Director
From: [email protected]
[mailto:[email protected]] On Behalf Of Hardy,
Elaine
Sent: Wednesday, April 02, 2014 2:19 PM
To: 'Evergreen Discussion Group'
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on a
held item?
PINES would like this feature to identify when the last copy held by a system
(not a branch) is deleted from the bib record for removing OCLC holdings as
well.
Elaine
J. Elaine Hardy
PINES & Collaborative Projects Manager
Georgia Public Library Service
1800 Century Place, Ste 150
Atlanta, Ga. 30345-4304
404.235-7128
404.235-7201, fax
[email protected]<mailto:[email protected]>
www.georgialibraries.org<http://www.georgialibraries.org>
www.georgialibraries.org/pines<http://www.georgialibraries.org/pines>
From:
[email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of
Elisabeth Keppler
Sent: Wednesday, April 02, 2014 8:06 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Notification is library is last owning on a
held item?
We'd also like to be able to identify when our own library's last copy is being
discarded or deleted so we can remove our OCLC holdings. We're on 2.4.3, if
that makes a difference, and would welcome any suggestions.
I can report holds for which there is no holdable copy (which we call "hopeless
holds") if that would help you, Buzzy. Using the Hold/Copy Ratio per Bib
report source, here are the filters and displays:
[Inline image 1]
[Inline image 2]
We use the results to generate emails or postcards to patrons letting them know
that we're unable to fill their hold. For materials older than a year, we
include instructions on how to request ILL. The example above filters on just
our holdings rather than the entire consortium's, but leaving off the Owning
Library Name filter would fix that.
Hope that helps,
Lise Keppler
Forsyth County NC
On Tue, Apr 1, 2014 at 9:10 PM, Buzzy Nielsen
<[email protected]<mailto:[email protected]>> wrote:
Hi folks,
Does anyone know, is there a feature in Evergreen, whether currently in place
or in development, that would notify a library is it's the last owning library
that carries a particular held item? We have a large consortium, 70+ libraries,
and patrons can place holds on pretty much any member library's items. It would
be really helpful if there could be some sort of alert if a library's that's
the last holding one marks a held item missing. That way, the patron's home
library could notify him/her that they're unable to get the item through the
consortium.
I hope that my question makes sense!
Cheers!
Buzzy
************************************
Library Director
Hood River County Library District
502 State Street
Hood River, Oregon 97031
541-387-7062<tel:541-387-7062>
http://hoodriverlibrary.org
--
Lise Keppler
Forsyth County Public Library
660 W 5th St
Winston Salem NC 27101
336-703-3070
