泛微OA之查找系统上共有多少流程

select *from workflow_flownode wffn
select *from workflow_nodebase wfnb --各个流程节点信息
select *from workflow_base wfb --各个流程名称信息
select *from workflow_type wft --流程对应的大目录信息
select *from workflow_nodegroup wfng
select *from workflow_groupdetail wfgd
select *from workflow_groupdetail_matrix wfgdm
select *from MatrixFieldInfo mfi --查找具体矩阵具体字段对应的编号
select *from MatrixInfo mi --查找具体矩阵

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%'

上一篇:C++知识点61——typename与class、模板编程与继承、模板类和友元、类模板与static成员


下一篇:无法加载文件或程序集“System.Net.Http,Version = 4.0.0.0,Culture = neutral,PublicKeyToken = b03f5f7f11d50a3a”