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

    Sorting by system number using SYS field in tab_sort

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

    Description:
    Is it possible to use the SYS field in tab_sort to sort by system number?

    Our library does not have a 001 or any other field with system number, but we want to sort records in GUI brief view by system number.

    Resolution:
    Add a line like this to the abc01 tab_sort:

    08 11 SYS ...

    Add to ./abc01/tab_expand:

    SORT-DOC expand_doc_sysno

    (This is creating a virtual field called SYS for sort purposes.)

    Update few records with UTIL F 1 13. You can now see that the system is creating z101 records with sort key 08:

    01 z101_sort \
    02 z101_rec_key \
    03 doc_number ...000000601
    03 sort_key .....08
    02 z101_data \
    03 alpha ........L
    03 text .........000000601

    Note: you will need to execute p_manage_27 to rebuild Z101.


    • Article last edited: 10/8/2013
    • Was this article helpful?