Report of course reserve items, grouped by course
- Article Type: General
- Product: Aleph
- Product Version: 20
Desired Outcome Goal:
Report of Course Reserve items, grouped by course -- where the Reserve items have an item status of "03".
Procedure:
> s+ xxx50
SQL> set echo off
set pause off
set term off
set show off
set verify off
set heading off
set feed off
spool course_items.lst
select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ substr (z11_rec_key,6,80), z30_rec_key, z30_barcode from z30, z103, xxx30.z11 where z30_item_status = '03' and substr (z30_rec_key,1,9) = substr (z103_rec_key_1,6,9) and z103_rec_key like 'XXX30%' and substr (z103_rec_key,6,9) = z11_doc_number and z11_rec_key like 'CNO-S%'
group by substr (z11_rec_key,6,80), z30_rec_key, z30_barcode order by substr (z11_rec_key,6,80), z30_rec_key, z30_barcode;
spool off;
Additional Information
The GUI Circulation will, of course, give one the List of Courses and, one can click on the Course Doc List, Items tab for each. But there is no facility in Aleph for producing a report of this information.
Category: Course reading (500)
- Article last edited: 10/8/2013