Hierarchical Grid Portlet Export To Excel Does Not Show 3rd Level

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

A hierarchical grid portlet with 3 levels does not show the 3rd level results with Export To Excel.

 

Cause

The following is the best-effort support for capability of exporting the 3rd level hierarchy.

SELECT   @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:DimId:DimId@,
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:Id:intId@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:Name:Name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:CASE WHEN Cnt = 0 THEN NULL ELSE DimId END:hg_has_children@
FROM (
SELECT
TO_CHAR(i.Id) dimId,
i.id, i.name,
( SELECT COUNT(*) FROM PrTask WHERE PrTask.PrProjectId = i.id ) cnt
FROM inv_investments i
WHERE i.odf_object_code = 'project'
AND @WHERE:PARAM:USER_DEF:STRING:hg_row_id@ IS NULL
AND ( @WHERE:PARAM:USER_DEF:INTEGER:hg_all_rows@  is null
      OR
      @WHERE:PARAM:USER_DEF:INTEGER:hg_all_rows@ =1
     )
AND i.id IN ( 5aaaaaa, 5bbbbbb)
UNION ALL
SELECT
TO_CHAR(T.PrProjectId) || TO_CHAR(T.PrId) dim_id,
T.PrId id,
CASE WHEN passRules.AllRows = 1 THEN '------' || T.PrName ELSE T.PrName END Name,
0
FROM PrTask T
LEFT OUTER JOIN ( SELECT NVL( @WHERE:PARAM:USER_DEF:INTEGER:hg_all_rows@, 0 ) AllRows FROM DUAL ) passRules ON 1=1
WHERE 1=1
AND (  ( T.PrProjectId = @WHERE:PARAM:USER_DEF:STRING:hg_row_id@
        AND @WHERE:PARAM:USER_DEF:INTEGER:hg_all_rows@  is null )
       OR
       ( t.prProjectId IN ( 5aaaaaa, 5bbbbbb)
         AND @WHERE:PARAM:USER_DEF:INTEGER:hg_all_rows@ =1 )
     )
) A
WHERE 1=1
AND @FILTER@

Resolution

After careful review by engineering, it has been decided that this issue will not be fixed.

Workaround:
Click on the page refresh option and the portlet will show in expanded mode.