p_item_05 problem

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

Description:
One of the libraries requested nine shelf list reports (p_item_05) is various call number ranges in the R classification. Eight of the reports completed quickly and correctly. The report on the RC501-RC1300 range, however, was empty. The library definitely owns books in the call number range/collection/item status. I ran it several times with the same result.
p_item_05
Fixed param: ABC50,RC504,RC1235,0,1,SUB-LIB,COLL,Y,01,Y,,outputfile_05,Y,00,

Resolution:
When running the retrieve query in SQL using "oder by", the order of call_numbers is alphabetical rather than numeric, as follows:

RC119,
RC1210
RC1230
RC1235
RC124
RC133
[...]
RC489
RC49
RC495
RC504
...

As you see, RC1235 is preceding the RC504 when sorted, and I this is what causes the empty output. In all the previous runs of p-item-05, the "location from" started with "1" (RJ1, RA1, R1) or had a close numbering (like from RA393 to RA399.5).
But this is the same problem as for location from "F2.3" to "F199" that also retrieved empty results.

This is caused by the "add_call_no_type" being first in the list of procedure in the tab_filing_call_no table.
Please change it to be listed *after* the lc_call_no, as in the example of demo usm50/tab/tab_filing_call_no.
Note that the add_call_no_type routine is optional.
Please see also KB items 6545, 8192-9591, 16384-4737.

After the change please run p_item_06, and then run the p_item_05 again.

This solved the problem.