SQL to get list of patrons with patron type is "RH", with barcode, address, etc.
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We need to generate a list of patrons where the patron type is "RH" We need the patron barcode and address (building, room number) and phone number.
How do I go about doing this?
Resolution:
If you had ARC, you could do this, but since you don't, the following SQL will give you that information:
> s+ abc50
SQL> select substr (z308_rec_key,3,20), z304_address, z304_telephone from z308, z304, z305 where z305_bor_type = 'RH' and rtrim ( substr (z305_rec_key,1,12)) = rtrim (substr (z308_id,1,12)) and substr (z305_rec_key,1,12) = substr (z304_rec_key,1,12) and z308_rec_key like '01%';
Additional Information
sql
- Article last edited: 10/8/2013