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. Circulation statistics by call number range

    Circulation statistics by call number range

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

    Description:
    Is it possible to get reports of circulation by LC class, such as sciences - Q-R?

    Ideally by patron status and period of time.

    Resolution:
    This is not one of the p_cir_30 General Circulation Statistics reports.

    The following SQL can be used to get this information:

    s+ abc50

    abc50@ALEPH18> select z35_bor_status, count(*) from z35 where z35_rec_key in (select substr (z30_rec_key,1,9) from z30 where z30_call_no > '$$hQ' and z30_call_no < '$$hS') and z35_event_type like '5%' and z35_event_date > '20071001' group by z35_bor_status;

    Note: the z35_event_type's 50-59 are all loans.

    Though I don't see it as one of the canned ARC reports, it could no doubt easily be created and formatted in ARC.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Circulation receipt prints as if trying to print regular 8 1/2 X 11 document
      • Circulation statistics services
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. 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