• 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