Report of patrons with specific global- or local-note value
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
We would like to add a note to the Circulation/ Global Patron Information/Global Blocks & Notes for patrons who have an ID for a service called Safari Books.
Is there a report (or SQL) which can be run to export a list of these patrons?
Resolution
The cir-05 ("Patron list") report lets you select patrons based on Local Block Code (z305_delinq_n) or Global Block Code (z303_delinq_n), but there is no option to select patrons based on Local Note or Global Note values in this or any other report.
The following SQL can be used to retrieve the patron ID and name of patrons with an "Additional Note 1" (in the Global Patron Information) with a value of "Safari Books":
SQL> select z303_rec_key, z303_name from z303 where z303_note_1 = 'Safari Books';
- Article last edited: 3-Aug-2018