• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
I have been asked to get the circulcation data for materials ordered for the collection for the past 5 years. I need to
report/sort: Number of circulations (most to least); titles and fund codes.

Resolution:
If you had ARC, such a report could be created relatively easily. Since you don't, the following SQL should give you what you want, in a very basic form:

select unique z30_no_loans, z13_title, substr(z30_rec_key,1,9) || '-' || substr(z30_rec_key,10,6), substr(z601_rec_key,1,50) from z30, usm01.z13, z601, z103 where
Z13_REC_KEY = substr (Z103_REC_KEY_1,6,9) and
substr (Z103_REC_KEY_1,1,5) = 'USM01' and
substr (Z103_REC_KEY,6,9) = substr (Z30_REC_KEY,1,9) and
substr (Z30_REC_KEY,1,9) = substr (Z601_REC_KEY_3,1,9) and
z30_open_date > '20031001' and
z30_material ^= 'ISSUE' and z30_material ^= 'ISSBD'
order by z30_no_loans desc;

• Article last edited: 10/8/2013