Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Finding the most checked-out item

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

    Description:
    Is there a fast way to find out what is the most checked-out item (the item with the most loans)?

    Resolution:
    Doing these two SQL commands will give you this info:

    1. SQL> select max (z30_no_loans) from z30;

    2. SQL> select z30_rec_key from z30 where z30_no_loans = nnn; <where "nnn" is the number returned by the first SQL> .

    See KB 8192-3274 in regard to the limit of this field to 999.


    • Article last edited: 10/8/2013