- 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?
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.
- Article last edited: 29-Aug-2016