select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
level,
zwkmzd_kmbh || ' '||zwkmzd_mc as title,
'icon-tree-folder' as icon,
zwkmzd_kmnm as value,
zwkmzd_kmbh || ' '||zwkmzd_mc as tooltip,
apex_util.prepare_url('f?p='||:app_id||':6001:'||:app_session||'::NO::P6001_ZWKMZD_KMNM:'||zwkmzd_kmnm) as link
from T_BHM_ZD_ZWKMZD
where zwkmzd_dwid=:P0_DWID and zwkmzd_year=substr(:P0_DATE,1,4)
start with ZWKMZD_SJKM is null
connect by prior zwkmzd_kmbh = ZWKMZD_SJKM
order siblings by zwkmzd_kmbh
之前写的树的SQL 在pl/sql 运行的也没问题,在APEX里怎么都出不来。是因为加了where条件
改成:
select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status,
level,
zwkmzd_kmbh || ' '||zwkmzd_mc as title,
'icon-tree-folder' as icon,
zwkmzd_kmnm as value,
zwkmzd_kmbh || ' '||zwkmzd_mc as tooltip,
apex_util.prepare_url('f?p='||:app_id||':6001:'||:app_session||'::NO::P6001_ZWKMZD_KMNM:'||zwkmzd_kmnm) as link
from (select * from T_BHM_ZD_ZWKMZD where
zwkmzd_dwid=:P0_DWID and zwkmzd_year=substr(:P0_DATE,1,4))
start with ZWKMZD_SJKM is null
connect by prior zwkmzd_kmbh = ZWKMZD_SJKM
order siblings by zwkmzd_kmbh
就好了