Circulation statistics by call number range
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Is it possible to get reports of circulation by LC class, such as sciences - Q-R?
Ideally by patron status and period of time.
This is not one of the p_cir_30 General Circulation Statistics reports.
The following SQL can be used to get this information:
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