• 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