I created a page with 2 tree regions. Both trees use different items and different queries. The first tree is displayed correctly. But the second one just contains the first item, if I don't display the first on via customizing the page or if I change the order of the trees the previoulsy invalid tree is shown correctly, but I didn't find a way to disply both correct at the same time.
Here is an example for my modified tree query:
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
end as status,
"NAME" as title,
null as icon,
CONCAT('AG', "AG_ID") as value,
null as tooltip,
'f?p=&APP_ID.:1:'||:APP_SESSION||'::::V_AGID,V_TGID:'||'AG'||"AG_ID",NULL as link
from "#OWNER#"."GROUPS_APPLICATION" GROUPS_APPLICATION
start with "GROUPS_APPLICATION"."PARENT_ID" IS NULL
connect by prior "GROUPS_APPLICATION"."AG_ID" = "GROUPS_APPLICATION"."PARENT_ID"
order siblings by "NAME"