[Evergreen-reports] Holds with no possible copies available

[John Rucker]

Terran,

Since we just upgraded to 3.5, that sample report was perfect. Thanks so much for sharing!

-John


John Rucker, Director
Branch District Library
10 E. Chicago St.
Coldwater MI 49036

RuckerJ at BranchDistrictLibrary.org
https://www.BranchDistrictLibrary.org
Direct: 517-279-7848
FAX 517-278-2342

> On Nov 2, 2020, at 11:14 AM, Terran McCanna <tmccanna at georgialibraries.org> wrote:
> 
> 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
> 
> 
> Join our email list 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
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports