select * from ( select t.*,d.TABLE_NAME,d.QUERY_SQL,d.data_control_col,d.id table_id,d.where_sql
from REPORT_KPI_INFO t
left join REPORT_KPI_TABLE_INFO d
on t.id = d.kpi_id
where t.kpi_status=1
<if test="keyword != null and keyword != ''">
and t.id in
(select t.id
from REPORT_KPI_INFO t
start with t.id in (select t.id
from REPORT_KPI_INFO t
where t.kpi_name like '%'||#{keyword}||'%')
connect by t.id = prior t.parent_id)
union
select t.*,
d.TABLE_NAME,
d.QUERY_SQL,
d.data_control_col,
d.id table_id,
d.where_sql
from REPORT_KPI_INFO t
left join REPORT_KPI_TABLE_INFO d
on t.id = d.kpi_id
where t.kpi_status = 1
and t.id in
(select t.id
from REPORT_KPI_INFO t
start with t.id in (select t.id
from REPORT_KPI_INFO t
where t.kpi_name like '%'||#{keyword}||'%')
connect by prior t.id = t.parent_id)
</if>
)
order by to_number(kpi_sort)
