[Evergreen-reports] Holds with no possible copies available

[Terran McCanna]

Here is a description of a report we use to identify holds that haven't
been captured - it doesn't specify *why* it hasn't been captured, but it
might help:

List of holds that were not captured prior to their expiration dates.
May be used
to identify missing copies and other possible problems.
-----------------------------------------
Uses Hold Request source.

Displayed Fields:

Hold Request -> Hold Type
Hold Request -> Pickup Library -> Short (Policy) Name as "Pickup Library"
Hold Request -> Bib Record link -> Target Bib Record -> Simple Record
Extracts -> Title Proper (normalized) as "Title"
Hold Request -> Bib Record link -> Target Bib Record -> Simple Record
Extracts -> Author (normalized) as "Author"
Hold Request -> Hold User -> Current Library Card -> Barcode as "Patron Barcode"
Hold Request -> Currently Frozen
Hold Request -> Thaw Date (if frozen)
Hold Request -> Hold Expire Date/Time


Base Filters:

Hold Request -> Pickup Library -> Organizational Unit ID (In list)
Hold Request -> Hold Cancel Date/Time (Is NULL)
Hold Request -> Fulfillment Date/Time (Is NULL)
Hold Request -> Capture Date/Time (Is NULL)
Hold Request -> Request Date/Time (Before (Date/Time))




Terran McCanna, PINES Program Manager
------------------------------

Georgia Public Library Service | University System of Georgia

2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341

(404) 235-7138 | tmccanna at georgialibraries.org

http://help.georgialibraries.org | help at georgialibraries.org

<https://www.facebook.com/georgialibraries>
<https://www.twitter.com/georgialibs>
<https://www.instagram.com/georgialibraries/>
<https://www.twitter.com/georgialibs>

Join our email list <http://georgialibraries.org> for stories of Georgia
libraries making an impact in our communities.



On Sat, Oct 31, 2020 at 4:20 PM John Rucker <
RuckerJ at branchdistrictlibrary.org> wrote:

> Hi all,
>
> I was wondering if anyone might have a report template they could share
> that they use for when a hold is placed on a title with only one item, then
> that item is lost/damaged and so the hold just hangs out there forever? So
> basically, looking for holds with no possible targets.
>
> Many thanks,
>
> John
>
> John Rucker, Director
> Branch District Library
> 10 E. Chicago St.
> Coldwater MI 49036
>
> RuckerJ at BranchDistrictLibrary.org
> http://www.BranchDistrictLibrary.org
> Direct: 517-279-7848
> 517-278-2341, ext. 115
> Fax: 517-278-2342
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20201102/2f8012c6/attachment.html>