oralce 中去除不要的节点数据 instr

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)

　　

posted @ 2018-07-19 09:38 赤子之心_timefast 阅读( ...) 评论( ...) 编辑 收藏