I'm having trouble creating a tree page on oracle apex .
I created the page, but apex displays the results, but not grouped by the specified node. It's a list of paid titles. I would like to create the Vendor node and below it the related titles.
I created a view to fetch the titles:
CREATE OR REPLACE VIEW V_TIT_FORN AS
SELECT P.NOME, T.CODIGO, T.CODFORNEC, T.PARCELA, T.DTVENCTO, T.VLRPARCELA, T.VLRPAGO
FROM PESSOA P
, TITULO T
WHERE P.CODIGO = T.CODFORNEC
AND T.TPTIT = 0;
And the page creation select looks like this:
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
"NOME" as title,
null as icon,
"CODIGO" as value,
null as tooltip,
null as link
from "#OWNER#"."V_TIT_FORN"
where DTVENCTO > TO_DATE('01/03/2016','DD/MM/RRRR')
start with "CODFORNEC" is NOT null
connect by prior "CODIGO" = "CODFORNEC"
order siblings by "NOME"
Note that I put start with as NOT NULL . If