Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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