Export to Excel Is Not Returning the Expected Results for an NSQL Portlet

Article Id: 106274
Status: Published
Updated On: 13-07-2018 06:52
Products:
CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise
Issue/Introduction:

Export to Excel does not return the expected results in an NSQL Portlet. Some columns are missing on the exported file (regardless of being regular Excel, Data Only or PowerPoint).

Steps to Reproduce

  1. Create a custom attribute of boolean type in projet object
  2. Create a query by giving nsql as: 
    SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:ocp.id:[email protected],
@SELECT:DIM_PROP:USER_DEF:BOOLEAN:RESOURCE:ocp.myboolean:[email protected]
FROM odf_ca_project ocp
WHERE 1 = 1 AND @[email protected]
  3. Create a portlet giving the query on step 2 as the data provider.
  4. Configure the portlet on the General page.
  5. Configure the attribute on the portlet.
  6. On the portlet, click on Options > Export to Excel.
Expected Results: The values in the portlet appear in the exported results.
Actual Results: Not all values in the portlet appear in the exported results.

Environment:

This issue has been reported in CA PPM 15.3.

Resolution:

This issue has been reported as DE42177 and fixed in CA PPM 15.5.