Title request screen displays "v." for each copy of title
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
Title requests are not working properly in certain cases: the title-request screen displays "v." for each copy of the title -- even though this title is not multi-volume and these items are multiple copies of the title, not multiple volumes.
Resolution:
The Title request display uses the z30_enumeration_a field to distinguish multi-volume titles -- in which case you need to display each volume. If this field is populated, it assumes that the title is multi-volume.
ABC50 item 003895422-000050 has "c.3" in the z30_description field and "3" in the z30_enumeration_a. This title is not multi-volume and the inclusion of the "3" in the z30_enumeration_a is incorrect.
I used SQL to delete the "3" from the z30_enumeration_a field of item 003895422-000050. The title-request for this title now displays correctly.
The following SQL shows that there are 27,177 cases in abc50 where the z30_description has 'c.' and the z30_enumeration_a is not null.
SQL> select count(*) from z30 where z30_description like 'c.%' and z30_enumeration_a is not null;
COUNT(*)
----------
27177
You should:
1. confirm that these are cases of multiple copies rather than multi-volume
2. run p_file_03 to back up the z30 table
3. Use SQL to make the z30_enumeration_a = null when z30_description like 'c.%'.
- Article last edited: 10/8/2013