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