APEX的树出错

 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

就好了