• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct; Direct; Local;

How can we find items in our collection which have had more than 1000 (2000, etc.) loans?

Resolution:
As noted in the article Does Aleph have a limit on the number of loans that show on the item record? , the z30_no_loans has this count, but it is limited to 999.  (Note:  the article describes a change in version 23.)

If you have items with more than 999 loans, then you need to use the following SQL:

SQL> select z35_rec_key || '-' || z35_item_sequence, count (*) from z35 where z35_event_type like '5%' group by z35_rec_key || '-' || z35_item_sequence having count(*) > nnnn;

<where "nnnn" is the number of loans you are checking for>.

Note: If you have deleted z35 records older than a certain year, then this count will only include loans for the years since then.

Category: Circulation

• Article last edited: 29-Aug-2016