CA PPM: Export to Excel (Data Only) that includes attachment fields sometimes shows the file name and sometimes shows the internal folder id.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Export to Excel (Data Only) that includes attachment fields sometimes shows the file name and sometimes shows the internal folder id. The ootb attachment field in Export to Excel contains the internal folder id. The custom attribute shows the file name correctly.

Steps to Reproduce:

1. Open object Requirements
2. Notice OOTB attribute:
Attribute Name=Attachment
Attribute ID=rqp_attachment
Data Type =Attachment
Attachment Style=Multiple Documents
Database Table= RQP_REQUIREMENTS
Database Column=ATTACHMENT
3. Create Custom Attribute:
Attribute Name=my_attachment
Attribute ID=my_attachment
Data Type =Attachment
Attachment Style=Multiple Documents
Database Table= odf_ca_requirement
Database Column=my_attachment
4. Add both attributes to the Edit Page
5. Create a Requirement instance with id=test. Save it. Populate Attribute 'Attachment' (select for example myfile1.txt) and Attribute 'my_attachment' (select for example myfile2.txt).
6. Add both attributes to the Requirements List.
7. Run query:
select attachment from RQP_REQUIREMENTS where code='test'
attachment =5212601.
8. Export to Excel. Observe columns.

Expected Result: 
The attachment fields in Export to Excel should be the file name

Actual Result: 
The ootb attachment field in Export to Excel contains the internal folder id.
The custom attribute shows the file name correctly.
Column 'Attachment' shows 5212601.000000
Column 'my_attachment' shows myfile2.txt

Environment

Release: 451-101-15.1-Clarity-Creator User License
Component:

Cause

 

 

Caused by DE29682

Resolution

 

 

Defect is fixed in 15.3.