[OPEN-ILS-GENERAL] Notification is library is last owning on a held item? OCLC Last Copy/Withdraws
Josh Stompro
stomproj at exchange.larl.org
Fri Dec 18 11:15:23 EST 2015
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: open-ils-general-bounces at list.georgialibraries.org [mailto:open-ils-general-bounces at list.georgialibraries.org] 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
ehardy at georgialibraries.org<mailto:ehardy at georgialibraries.org>
www.georgialibraries.org<http://www.georgialibraries.org>
www.georgialibraries.org/pines<http://www.georgialibraries.org/pines>
From: open-ils-general-bounces at list.georgialibraries.org<mailto:open-ils-general-bounces at list.georgialibraries.org> [mailto:open-ils-general-bounces at list.georgialibraries.org] 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 <buzzy at hoodriverlibrary.org<mailto:buzzy at hoodriverlibrary.org>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20151218/4e836178/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 40322 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20151218/4e836178/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 21789 bytes
Desc: image002.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20151218/4e836178/attachment-0003.png>
More information about the Open-ils-general
mailing list