New books which have more than 3 hold requests

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 16.02

Description:
We need to generate a report for some new books which have more than 3 requests in past few months.

Is the historic data of Hold requests stored in any table?

Resolution:
The hold request history can be found in both the z35 and z37h tables. The problem with the z37h is that it is written only after the hold has been filled or deleted, so the z35 is better for this purpose.

You can do the following:

select z35_rec_key from z35, z30 where z35_event_type like '7%' and z35_rec_key = substr (z30_rec_key,1,9) and z30_open_date > '20061001' group by z35_rec_key having count (*) > 3;

[Jerry Specht]
[1/16/2007 1:32:21 AM Jerry Specht]

Article last edited: 10/8/2013