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