Skip to main content
  • Subscribe by RSS
  • ExLibris Dev

    How to find items with more than nnnn loans?

    • 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.

    Category: Circulation

    • Article last edited: 29-Aug-2016
    // feedback widged