oralce 中去除不要的节点数据 instr
select taskobject1_.task_id,
taskobject1_.task_name,
p.participant_id
from PM_WBS_RELATION wbsrelatio0_, PM_TASK_OBJECT taskobject1_,PM_TASK_PARTICIPANT p
where taskobject1_.task_id = wbsrelatio0_.child_task_id
and taskobject1_.task_model_type = 'taskModel'
and taskobject1_.TASK_FLAG = 'approvalTask'
and taskobject1_.task_id =p.task_id
and p.PARTICIPANT_TYPE='1'
and wbsrelatio0_.parent_task_id = '89F21242B4E449948B038FC1CB595641'
and taskobject1_.task_id not in
(select child_task_id
from PM_WBS_RELATION tt, PM_TASK_OBJECT ttt
where 1 = 1
and tt.child_task_id = ttt.task_id
and tt.parent_task_id = '89F21242B4E449948B038FC1CB595641'
and ttt.TASK_FLAG='approvalTask'
and instr(task_name, '(设计)') > 0)--不包括设计人员
order by pm_wbs_cord_sort(wbsrelatio0_.wbs_code)