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. Patron list sort order

    Patron list sort order

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    We have a situation where two patrons with hyphenated last names are sorting differently in the patron list when sorted by name. The patrons are Johnson-One, Mary, and Johnson-Two, Cindy. The patron names look like they are entered similarly, but they are not sorting the same way. Johnson-One sorts in with the Johnson, O... names, but Johnson-Two sorts at the end of all the Johnsons. And Johnson-Two cannot be retrieved by searching "Johnson-Two", but Johnson-One can be retrieved by searching "Johnson-One". What is determining the different sort routines? And why did these two patrons, who I believe were both manually entered, end up with different sorting parameters?

    Resolution:
    The creation of the Z303_NAME_KEY is controlled by proc 55 in your ADM or user library's tab_filing, specifically the BORROWER-NAME-KEY routine that it calls. It appears that the two patrons you cited may have been created in different versions of Aleph and may have been done with different rules. The Z303_UPDATE_DATE field in the Johnson-One record is: 20070418 while the most recent update to the Johnson-Two record was: 20050307. There are quite a few differences in the other fields of these two records that lead me to believe they were created in different Aleph versions.

    If you would like to get all of the hyphenated names to sort the same way, you could run the p-manage-64 utility in the circ module. This should update all of the records according to the current rules. You may wish to review and possibly even change "the rules" before you do this. You can see how various names would be normalized by using util f/1/3 with routine 55 from tab_filing.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Patron list not properly limiting when Display Local Patrons Only is checked
      • Patron Loader (file-20) does not process any patron data
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 17.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