mysql：泛微E9历史流程种类归档情况统计(未归档包含创建节点)

1、根据字典找到相关流程表单，核心表单在workflow_requestbase

2、具体查询代码如下：

select B.workflowname 流程名称,C.typename 类型名称,count(*) 合计条数,
SUM(CASE WHEN A.currentnodetype != 3 THEN 1 ELSE 0 END) AS 未归档流程个数,
SUM(CASE WHEN A.currentnodetype = 3 THEN 1 ELSE 0 END) AS 已归档流程个数
from workflow_requestbase A, workflow_base B 
LEFT JOIN workflow_type C ON C.id = B.workflowtype -- 流程类型
where A.workflowid=B.id 
group by B.workflowname