{"sql":"select \"bwf\".\"id\" as \"流程任务id\", \"bwf\".\"activityCode\" as \"任务节点id\", \"bwf\".\"activityName\" as \"任务节点名称\", \"bwf\".\"instanceId\" as \"流程实例id\", \"bwf\".\"participant\" as \"任务处理人id\", \"bwf\".\"participantName\" as \"任务处理人姓名\", \"bwf\".\"startTime\" as \"任务接收时间\", \"bwf\".\"receiveTime\" as \"任务处理时间\", round(\"bwf\".\"usedtime\" / 1000, 2) as \"耗时（秒）\", round(\"bwf\".\"usedtime\" / 60000, 2) as \"耗时（分）\", round(\"bwf\".\"usedtime\" / 3600000, 2) as \"耗时（小时）\", round(\"bwf\".\"usedtime\" / 86400000, 2) as \"耗时（天）\", \t   round(\"bwf\".\"originatorUsedTime\" / 1000, 2) as \"发起人耗时（秒）\", round(\"bwf\".\"originatorUsedTime\" / 60000, 2) as \"发起人耗时（分）\", round(\"bwf\".\"originatorUsedTime\" / 3600000, 2) as \"发起人耗时（小时）\", round(\"bwf\".\"originatorUsedTime\" / 86400000, 2) as \"发起人耗时（天）\", \t   round(\"bwf\".\"participantUsedTime\" / 1000, 2) as \"参与人工作日历耗时（秒）\", round(\"bwf\".\"participantUsedTime\" / 60000, 2) as \"参与人工作日历耗时（分）\", round(\"bwf\".\"participantUsedTime\" / 3600000, 2) as \"参与人工作日历耗时（小时）\", case \"bwf\".\"approval\" when 'AGREE' then '同意' when 'REJECT' then '驳回' when 'FORWARD' then '转办' when 'CANCELLED' then '取消' when 'UNDO' then '未处理' when 'TIMEOUT_CANCELLED' then '超时取消' else '超时通过' end as 任务操作, case \"bwf\".\"state\" when 'FINISHED' then '已完成' when 'CANCELLED' then '被取消' when 'REVOKE' then '被撤回' when 'TIMEOUT_CANCELLED' then '超时作废' else '已完成' end as \"任务状态\", \"bwf\".\"workflowCode\" as \"流程模版编码\", \"wh\".\"workflowName\" as \"流程模板名称\", \"bwf\".\"originator\" as \"流程发起人id\", \"bwf\".\"originatorName\" as \"流程发起人姓名\", \"bwi\".\"startTime\" as \"流程发起时间\", \"bwi\".\"finishTime\" as \"流程结束时间\", \"bwi\".\"state\" as \"流程状态\", \"wh\".\"schemaCode\" as \"所属模型编码\", \"haf\".\"name\" as \"所属模型名称\", \"bwf\".\"appCode\" as \"所属应用编码\", \"hap\".\"name\" as \"所属应用名称\", \"hou\".\"departmentId\" as \"任务处理人部门id\", \"hod\".\"name\" 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_function\" \"haf\" on \"wh\".\"schemaCode\" = \"haf\".\"code\" left join \"h_app_package\" \"hap\" on \"bwf\".\"appCode\" = \"hap\".\"code\" left join \"h_org_user\" \"hou\" on \"bwf\".\"participant\" = \"hou\".\"id\" left join \"h_org_department\" \"hod\" on \"hou\".\"departmentId\" = \"hod\".\"id\" ","title":"已办任务","dbConfig":null,"encrypted":true,"dynamicParams":null,"sqlParams":null}