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

Description:
We need create a report of list items that got circulated in the past year. In that report we need to have titles.barcode,call No, Number of Loans.

Resolution:
The following SQL will give you the title, barcode,call No, Number of Loans for items which circulated in the past year. The number of loans is the number of loans in *all* years. If you want the number of loans just for last year, that would be a bit more complicated....

SQL-LNL50> select unique Z13_TITLE, Z30_BARCODE, Z30_CALL_NO, z30_no_Loans from LNL01.Z13, Z30, Z103, Z35 where z30_rec_key = z35_rec_key || to_char (z35_item_sequence, 'FM000000') and z35_event_date >= '20060415' and z35_event_date <= '200704015' and z35_event_type like '5%' and 'LNL01' || Z13_REC_KEY = Z103_REC_KEY_1 and substr (Z103_REC_KEY,1,14) = 'LNL50' || substr (Z30_REC_KEY,1,9);