{"sql":"select \"bwf\".\"id\" as \"流程任务id\", \"bwf\".\"activityName\" as \"任务节点名称\", \"bwf\".\"participant\" as \"任务处理人id\", \"bwf\".\"startTime\" as \"任务接收时间\", \"bwf\".\"receiveTime\" as \"任务处理时间\", \"wh\".\"workflowName\" as \"流程模板名称\", \"hap\".\"name\" as \"所属应用名称\", \"hap\".\"code\" as \"所属应用编码\", \"hou\".\"departmentId\" as \"任务处理人部门id\", \"hbc1\".\"cnt\" as \"传阅次数\", \"hbc2\".\"cnt\" as \"协办次数\", \"hbc3\".\"cnt\" as \"加签次数\", \"bwf\".\"originatorDeptQueryCode\" as \"部门查询字段\" from \"biz_workitem_finished\" \"bwf\" left join \"biz_workflow_instance\" \"bwi\" on \"bwf\".\"instanceId\" = \"bwi\".\"id\" left join \"h_workflow_header\" \"wh\" on \"bwf\".\"workflowCode\" = \"wh\".\"workflowCode\" left join \"h_app_package\" \"hap\" on \"bwf\".\"appCode\" = \"hap\".\"code\" left join \"h_org_user\" \"hou\" on \"bwf\".\"participant\" = \"hou\".\"id\" left join(select \"workItemId\", count(*) as \"cnt\" from \"h_biz_comment\" where \"actionType\" = 'CIRCULATE' group by \"workItemId\") \"hbc1\" on \"bwf\".\"id\" = \"hbc1\".\"workItemId\" left join(select \"workItemId\", count(*) as \"cnt\" from \"h_biz_comment\" where \"actionType\" = 'ASSIST' group by \"workItemId\") \"hbc2\" on \"bwf\".\"id\" = \"hbc2\".\"workItemId\" left join(select \"workItemId\", count(*) as \"cnt\" from \"h_biz_comment\" where \"actionType\" = 'ADD_WORKITEM' group by \"workItemId\") \"hbc3\" on \"bwf\".\"id\" = \"hbc3\".\"workItemId\"","title":"已办任务操作数据","dbConfig":null,"encrypted":true,"dynamicParams":null}