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

    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