select case when charindex('~`~`7',typename)>0 then substring(typename,7,charindex('`~`8 ',typename)-7) else typename end,
case when charindex('~`~`7',workflowname)>0 then substring(workflowname,7,charindex('`~`8 ', workflowname)-7)
else workflowname end
from workflow_type wft --流程对应的大目录信息
left join workflow_base wfb on wfb.workflowtype=wft.id
where workflowname not like '%停用%'
and workflowname not like '%V%'
泛微:显示所有流程名SQL
最新推荐文章于 2024-04-08 22:36:39 发布