- Article Type: General
- Product: Aleph
- Product Version: 17.01
When the "Display Local Patrons Only" box is checked, we don't get any results. When the box is un-checked, we get results. Why is that?
This occurs when there are no records in the Z353 table with this ADM library in their Z353-LIBRARY field (the first 5 bytes of z353_rec_key). In addition to the blank Z353-LIBRARY entries, there should also be Z353s containing the ADM library in this position..
Though the Z353 records reside in the $usr_library, the p_cir_25 job which produces them needs to be run in the *ADM* library. The problem described occurs when the job is run for the $usr_library rather than the ADM library. If you have multiple ADM libraries, p_cir_25 needs to be run for each of them.
The following SQL can be used to display all the z353 records for a particular patron:
SQL> select z353_rec_key from z353 where z353_id = 'xxxxxxxx';
<where 'xxxxxxxx' is the patron ID (the Z303-ID) >
See KB 16384-1442 for another cause of this problem.
- Article last edited: 10/8/2013