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

    How to sort items per z30-call-number?

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    This SI is related to sorting of items in ALEPH. In the attached file you will see a list of items from BIB record 87579 in our production server. Please note the highlighted item which is placed in the following position, regarding the Call Number column:

    YRB VEN BCV InE 1992
    YRB VEN BCV InE 2000
    YRB VEN BCV InE 1993

    Note: the item list is, in fact, sorted by SEQ column.

    The option selected in the Sort Option field is ITEM-7 that I've created for try-and-error tests. It has the following setup in tab_z30_sort:

    ITEM-7 A 03 A 05

    where 05 means:

    ! ------------------------------------------------------
    ! 05 - by location (using sublibrary), then sequence
    ! ------------------------------------------------------
    ! sub_library+
    ! item-sequence;

    I thought that location could be z30-call-no but it looks like it is only the sub-library. Anyway, I went through the tab_z30_sort heading and I didn't find any option to sort the list by Call Number (from z30-call-number, not from Holdings). Is there anyway to sort the Item lists in ALEPH based on the z30-call-number field?

    Resolution:
    The z30_call_no is not an element in any of the tab_z30_sort's. The system anticipates that the enumeration/chronology fields will be correctly populated -- which it seems it is not in this case. For instance, we see this:

    iad50@ALEPH0> select z30_call_no, Z30_CHRONOLOGICAL_I from z30 where z30_rec_key = '000087579000180';
    **** Hit return to continue ****

    Z30_CALL_NO
    --------------------------------------------------------------------------------
    Z30_CHRONOLOGICAL_I
    --------------------
    $$hYRB VEN BCV InE 1986
    2005

    Most of the records seem to have "2005" in the Z30_CHRONOLOGICAL_I field.

    My idea would be to correct the Z30_CHRONOLOGICAL_I as follows:

    SQL> update z30 set Z30_CHRONOLOGICAL_I = substr (z30_call_no,20,4) where z30_rec_key like '000087579%';

    That is the only method I can think of for achieving the sort you want.


    • Article last edited: 10/8/2013