flowable的流程任务统计sql

一、统计所有任务统计数量

select count(*) from act_hi_procinst

二、按天统计任务数量

SELECT DATE_FORMAT(START_TIME_, '%Y-%m-%d') AS days,COUNT(1) AS num FROM act_hi_procinst GROUP BY DATE_FORMAT(START_TIME_, '%Y-%m-%d') ORDER BY START_TIME_

三、统计流程总数

select sum(c.num) as total from (select DATE_FORMAT(b.DEPLOY_TIME_, '%Y-%m-%d') AS days , count(a.KEY_) as num from (select DEPLOYMENT_ID_,KEY_,MAX(VERSION_) from act_re_procdef GROUP BY KEY_) a LEFT JOIN act_re_deployment b on a.DEPLOYMENT_ID_ = b.ID_ GROUP BY DATE_FORMAT(b.DEPLOY_TIME_, '%Y-%m-%d') ORDER BY b.DEPLOY_TIME_) c

四、按天统计流程数量

select DATE_FORMAT(b.DEPLOY_TIME_, '%Y-%m-%d') AS days , count(a.KEY_) as num from (select DEPLOYMENT_ID_,KEY_,MAX(VERSION_) from act_re_procdef GROUP BY KEY_) a LEFT JOIN act_re_deployment b on a.DEPLOYMENT_ID_ = b.ID_ GROUP BY DATE_FORMAT(b.DEPLOY_TIME_, '%Y-%m-%d') ORDER BY b.DEPLOY_TIME_