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