泛微oa数据库之查询流程批次条件、出口条件

select
e.typename as 流程目录,
a.id 流程ID,
a.workflowname as 流程名称,
b.groupname as 流程节点,
c.conditioncn as 出口条件,
d.conditioncn as 批次条件
from
workflow_base a,
workflow_nodegroup b,
workflow_nodelink c,
workflow_groupdetail d,
workflow_type e
where a.id=c.workflowid
and c.nodeid=b.nodeid
and d.groupid=b.id
and a.workflowtype=e.id
and (c.conditioncn IS NOT NULL OR d.conditioncn IS NOT NULL )
and e.typename not in ('2013停用','2014停用','2015停用','2016停用')
AND e.typename not in ('2013停用','2014停用','2015停用','2016停用','管理员测试','系统默认工作流','资产管理','项目管理','报表填报')
AND a.workflowname LIKE '0%'
order by a.id, b.groupname

请在评论区留言，共同探讨~~~

如有需要，请联系微信：hdygzh2019 同时请说明来意，共同进步！！！