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

    Circulation statistics by call number range

    1. Last updated
    2. Save as PDF
    • 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