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. Circ statistics by patron type (z305_bor_type) rather than patron status

    Circ statistics by patron type (z305_bor_type) rather than patron status

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Desired Outcome Goal:
    Create report with:

    Patron type Number of loans Number of renewals

    for specific time period.

    Procedure:
    Substitute "Patron Type" (z35_bor_type) for "Patron Status" (z35_bor_status) in running the cir-30 (General Circulation Statistics):

    > am
    > cd sql_stat
    > cp -p cir_stat_07_stat_bor_param.sql cir_stat_07_stat_bor_param.sql.save

    vi cir_stat_07_stat_bor_param.sql and change the two occurrences of the string "Z35_BOR_STATUS" to "Z35_BOR_TYPE".

    Then do the same for cir_stat_13_stat_loan_param.sql:

    > cp -p cir_stat_13_stat_loan_param.sql cir_stat_13_stat_loan_param.sql.save

    vi cir_stat_13_stat_loan_param.sql and change the two occurrences of the string "Z35_BOR_STATUS" to "Z35_BOR_TYPE".

    Then submit cir-30 choosing "Patron Status" as the "Group Results By" parameter. Since the above change has been made, it will look for and use the z35_bor_type (instead of z35_bor_status).

    Additional Information

    Note: EL Commons Code Contributions from Natalie Sturr at http://www.exlibrisgroup.org/display/Aleph/Aleph+Custom+Services+-+46+Services+from+SUNY contain custom-01 and custom-02 reports for borrower type:

    Circ statistics by sublibrary/borrower type/item status
    Circ statistics by sublibrary/borrower type/borrower status/item status

    Multiple pieces (in ./aleph/proc, ./alephm/source/butil, ./pc_b_lng, ./alephm/sql_tab) are required for implementing this, so it is more complicated than the changes shown above. These reports are part of a "suite" of custom jobs.

    Category: Circulation (500)

    Subject: Services


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Circ Return "Override Date" return time stays in effect after accidentally clicking button
      • circ-status call aborts
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Circulation (500)
      3. contype:kba
      4. Prod:Aleph
      5. Services
      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