17,377
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO tt_v_t2_2
SELECT t.ActivityName,
COUNT(*) InstanceCount
FROM ( SELECT a.ActivityName
FROM bwwf_Tracking_Activities ta
LEFT JOIN bwwf_Activities a
ON ta.ActivityId = a.ActivityId
WHERE ta.WorkflowInstanceId IN ( SELECT workflowinstanceid
FROM tt_v_workflows ) ) t
GROUP BY t.ActivityName
UNION
SELECT '完成' ActivityName,
COUNT(*) InstanceCount
FROM bwwf_Tracking_Workflows
WHERE STATE = 2
AND WorkflowInstanceId IN ( SELECT workflowinstanceid
FROM tt_v_workflows )
UNION ALL
SELECT '取消' ActivityName,
COUNT(*) InstanceCount
FROM bwwf_Tracking_Workflows
WHERE STATE = 99
AND WorkflowInstanceId IN ( SELECT workflowinstanceid
FROM tt_v_workflows )