• 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%';