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

    Circulation count by Collection, call number prefix

    • 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