Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. How to sort items per z30-call-number?

    How to sort items per z30-call-number?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to sort field 001 at the end of a record during export
      • How to sort records in the "Create set of down-linked records" in OPAC
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved