• 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