• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
The sort types "Loan Title" and "Loan Author" in the list of loans in the patron information in GUI circulation are not working properly. Also in the list of cash records the sort referring to "Title" and "Author" is wrong.

Resolution:
Please check the setup of your file ./xxx01/tab/tab_sort. In the tables ./xxx50/tab/tab_z31_sort and tab_z36_sort the sort type "title" (code "00" in tab_z31_sort and "09" in tab_z36_sort) refers to sort key "03" in tab_sort, the sort type "author" (code "05" in tab_z31_sort and "10" in tab_z36_sort) refers to sort key "02" in tab_sort. This is hardcoded and can not be changed.

So this sytem behaviour implies that in ./xxx01/tab/tab_sort you have define "02" as the author sort and "03" as the title sort:

[...]
02 01 1#### a       700## a                                                 00 00
03 11 245## a     2 240##       2                                           00 00
[...]

If you have different sort type definitions in tab_sort (e.g. "02" as title sort and "03" as year sort) the sort of cash and loan records may not work as expected.

To solve this problem, you can update your table ./xxx01/tab/tab_sort so that "02" is the authort sort and "03" is the title sort.

Please note:
- After each change of tab_sort you will need to rebuild the sort keys in the database using p_manage_27.
- There are several places in other ALEPH-tables that need to be updated after a change of the tab_sort:
- SO-section in ./xxx01/tab/pc_tab_sear.lng
- Col. 1 + 3 in ./xxx01/tab/www_f_sort_heading.lng
- Col. 4 in ./xxx01/tab/www_tab_short.lng
- Parameter "setenv www_sort_field" in $alephe_tab/www_server.conf
- Parameter "setenv pc_sort_field" in $alephe_tab/pc_server_defaults