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 count by Collection, call number prefix

    Circulation count by Collection, call number prefix

    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:
    Report of number of times items in Collection "zzzz", with call numbers beginning with "xx" have circulated in the past year.

    Procedure:
    > s+ xxx50
    SQL> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ count(*) from z35, z30 where z30_rec_key = z35_rec_key || lpad (Z35_ITEM_SEQUENCE,6,'0') and z30_call_no like '$$hxx%' and z30_collection = 'zzzz' and z35_event_type like '5%' and
    z35_event_date > 'yyyymmdd' and z35_event_date < 'yyyymmdd';

    Additional Information

    Specific example for Collection "Main", call number beginning with "ML":

    SQL> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ count(*) from z35, z30 where z30_rec_key = z35_rec_key || lpad (Z35_ITEM_SEQUENCE,6,'0') and z30_call_no like '$$hML%' and z30_collection = 'MAIN' and z35_event_type like '5%' and
    z35_event_date > '20120630' and z35_event_date < '20130701';

    Category: Circulation


    • Article last edited: 12/2/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Circulation client crashes when creating a booking request
      • Circulation GUI crashes
    • Was this article helpful?

    Recommended articles

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