Hyperlink issue in exported excel

Document ID : KB000076439
Last Modified Date : 04/04/2018
Show Technical Document Details
Issue:
Export to Excel changes the link generated over a portlet.

STEPS TO REPRODUCE 
  1. Go to Administration > Studio > Queries, create New 
  2. Fill in any info, Save and Continue 
  3. Use the following NSQL to retrieve Document ID and Name.
    SELECT 
    @SELECT:DIM:USER_DEF:IMPLIED:PROJECT:CDF.ID:Document_ID@,
    @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:CDF.NAME:Document_NAME@
    FROM CLB_DMS_FILES CDF
    WHERE
    @FILTER@
  4. Click on Linking tab, then New 
  5. Select "Document" Action, map "File ID" to "document_id", and "File Name" to "document_name", then Save, then Return 
  6. Go to Administration > Studio > Portlets, create New > Grid Portlet 
  7. Fill in any info, use the query created as Data Provider, then Save, Finish and Open 
  8. Go to List Column Section > Layout, then add document_name in the Selected Columns, then Save 
  9. Go to List Column Section > Fields, then open document_name properties 
  10. For the Link attribute, choose the link created earlier in the dropdown, then Save and Return 
  11. Go to Home > Portfolio Management > Projects, open any project (assuming full rights), and open the Collaboration tab. 
  12. In the Actions dropdown, choose Add documents 
  13. Upload at least one file 
  14. Add the portlet created earlier to any page (e.g., in Home > Personal > General tab) 
  15. Open the portlet. Try to download the file that was uploaded from the portlet. The link generated will look like:
    http://<server>/niku/app?action=dms.viewFile&fileName=file.txt&RhXm0r7tSeUqEr=true&filedownload=filedownload&fileId=5020500&RhXm0r7tSeUqEr=true 
    (note that after the server name, there is: /niku/app?action=dms.viewFile... - this link works) 
  16. Use Options > Export to Excel (Data Only) 
  17. Open the exported file, click in the link.
Expected Results: Link is the same, link opens when clicked. 
Actual Results: Link has been changed. It now looks like:
http://<server>/niku/nu#action:dms.viewFile&fileName=file.txt&RhXm0r7tSeUqEr=true&filedownload=filedownload&fileId=5020500 
(note that after the server name, there is: /niku/nu#action:dms.viewFile... - this link does NOT work)
Environment:
This issue has been reported in CA PPM 14.3 and verified on CA PPM 15.2 as well.
Cause:
This issue has been logged as DE33519 to Engineering.
Resolution:
This issue has been fixed in CA PPM 15.3.