How to get a list of titles loaned by a patron in the past six months?

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

Article Type: General
Product: Aleph
Product Version: 16.02

Description:
How do you get the list of titles that a patron has loaned in the past six months?

Resolution:
SQL-ABC50> select Z13_TITLE, z35_event_date from ABC01.Z13, Z35, Z103 where Z13_REC_KEY = substr (Z103_REC_KEY_1,6,9) and substr (Z103_REC_KEY_1,1,5) = 'ABC01' and substr (Z103_REC_KEY,6,9) = substr (Z35_REC_KEY,1,9) and z35_event_type like '5%' and and z35_id = 'nnnn' and z35_event_date > '200601001';

Article last edited: 10/8/2013