Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Course list does not sort correctly

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

    Description:
    In the PC client, the Course reading list does not sort correctly, other than the Course Number sort itself.

    The display order is correct as we toggle between sort options, but the starting point (io_z108_start2, io_z108_start3, etc) only work when we click the radio button the first time.

    When text is entered, the display order starts from the very top of the Z108 index in question.

    Resolution:
    This is like KB 8192-2935.

    The programs are looking at the Z108_COURSE_NAME_KEY, Z108_DEPARTMENT_KEY, and Z108_INSTRUCTOR_NAME_KEY.

    SQL showed that these were mixed-case. (They should be uppercase.)

    Here's what we see on the usm50 (that is, a correct uppercase KEY):

    usm50> select Z108_DEPARTMENT, Z108_DEPARTMENT_KEY from z108 order by Z108_DEPARTMENT_KEY;

    Z108_DEPARTMENT
    --------------------------------------------------------------------------------
    Z108_DEPARTMENT_KEY
    --------------------------------------------------------------------------------
    Behavioral Sciences
    BEHAVIORAL SCIENCES

    Behavioral Sciences
    BEHAVIORAL SCIENCES
    <etc.>

    Running p_manage_64 for the Z108 in the xxx50 library corrected the problem.

    (keywords: p-manage-64 manage_64 FAQ)


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged