SQL to retrieve hold requests for specific library (in Alma migration)
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
In migrating to Alma, we want to retrieve a list of hold requests for specific library/sublibrary.
Resolution
> s+ xxx50
SQL> select z30_barcode, z37_id, z37_open_date, z37_request_date, z37_end_request_date from z30, z37 where z30_sub_library = 'XXXXX' and z37_status = 'S' and substr (z37_rec_key,1,15) = z30_rec_key;
<Note: the "z37_status = 'S'" limits the results to items which have been placed on the hold shelf.>
- Article last edited: 16-Aug-2016