• 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