A hierarchical grid portlet with 3 levels does not show the 3rd level results with Export To Excel.
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@
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.