Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. How to list patrons with particular patron status.

    How to list patrons with particular patron status.

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Desired Outcome Goal:
    A list of yyy50 patrons with BOR-STATUS of "11" (in a multi-ADM set-up).

    Procedure:
    Use the following SQL (where xxx50 is your $usr_library):

    > s+ yyy50
    yyy50@ALEPH21> select z303_name from XXX50.z303, z305 where substr (z305_rec_key,1,12) = z303_rec_key and z305_bor_status = '11' order by z303_name asc;

    Category: Circulation (500)

    Subject: Patrons


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to link z35 records to associated z30, z36, etc., records in SQL
      • How to load Item records created by manage-500
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. Circulation (500)
      3. contype:kba
      4. Patrons
      5. Prod:Aleph
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved